Update a brochure and order sheet mostly graphics

Update a brochure and order sheet mostly graphics

Closed - This job posting has been filled.

Job Description

I have an existing information sheet/brochure and an order sheet that needs to be updated/redesigned

the information sheet/brochure is based on a retail planogram showing layout of products that go onto a retail display stand. It is mainly graphics. It is needed to show staff where each product is displayed on the stand and to allow them to reorder products from the order sheet when stock is low.

The existing brochure/information sheet is 8 pages but it can be simplified to 4 or 6 pages most of the layout is done just needs updating with different layout and new products.

Each product has its own product code and barcode these will need to be displayed on the planogram and linked to the order sheet. You will need to be able to generate barcodes and add the product code and description to the barcode. most of this is already done but some will need this added to barcode

The order sheet will need to be redesigned to look more professional also. The current order sheet is an excel spreadsheet i need this to be set up as 3 different order sheets(location specific) and to incoporate thumbnail images of the products and the barcode(image) of each product

There will be three different versions for different locations.minor changes will be needed on the other 2(basically swapping out location specific items)

the brochure when finished will need to be sent to me in illustrator format and pdf and be ready for printing. The order sheet needs to be done on excel

Please send an image of the barcode 1111111111116 in your application so i know you have read the actual brief