Project 10 is to prepare advertisements for 530 general hire clients, for uploading to our web site.
These are the same clients you worked on in Project 1.
Fingerprint have already prepared csv spreadsheets for each client, in which you recorded their names, addresses, logos, etc. The advertisements for each client are now to be recorded on a new csv spreadsheet - a separate spreadsheet per client.
A spreadsheet containing the csv advertisement template is attached. It has the same column format as you used for the party hire advertisements. It is essential that the list of products in the template is not changed, because the same list is used to prepare individual advertisements as you will see below. It lists 10 images for each product. We only need one image for each product in an advertisement, so in order to provide variety you should rotate the product images so that 10% of clients use image 1 for each product, 10% use image 2, etc.
A spreadsheet is attached which contains a list of general hire clients in Sheet 1. These have been coded 1-20 to roughly sort the clients into their industry types. The clients in each industry type are recorded in separate columns in Sheets 2 to 5. For each client in sheets 2 to 5, the number 1 has been recorded in the relevant column to indicate the equipment types the client has available for hire. You can see that many of the general hire clients in sheet 2 have a large number of products available for hire, whereas most of the clients in sheets 3 to 5 have just a few products.
Another spreadsheet is attached which I used as a worksheet to prepare an example advertisement for Boom Sherrin. In step 1, I copy pasted the list of products from the csv template in (1) above. In step 2, I inserted an additional temporary column and copy pasted the list of products that Boom Sherrin have available for hire. In step 3, I deleted rows for all product categories not offered for hire by Boom Sherrin. Also, since we only want one image per advertisement, I cut and pasted the image 2 list in the csv template into the img 1 column in this worksheet and deleted all the other images. I also deleted the temporary column of Boom Sherrin products for hire.
After completing the exercise described in (3) above, I copy pasted the step 3 spreadsheet into a new file and saved it as a csv file. Copy attached. This is the csv file we use to upload the Boom Sherrin advertisements to our web site
The above procedure worked well for clients having a lot of products for hire, but if you can think of an easier approach (especially for clients having just a few products) then feel free to adopt it.