Database Format Guide



Image

JLP Database guide

 

From 1 April 2011, we are implementing changes to the way that JLP (John Lewis Partnership labels are ordered.

After a review of the current process, it became apparent that the system needed overhauling.

A large percentage of the Excel sheets we receive need editing in order make them usable with our
software. The most common issues are sheets that include unwanted data i.e. customers part numbers, order
numbers, cell formatting etc.

Therefore, from 1 April 2011 we will only accept orders that are supplied using a correctly formatted
Excel sheet.

The Guide outlined on these pages is for your reference. It shows you the exact layout we require.

Failure to follow this guide could lead to delays in your order.

Thank you for your understanding in this matter.

guide / examples

 

Item 1 Main

 

Processing

Please start with the sheet from the JLP Connect Website

All the information we require is on this form. Next move on to step 2.

 

 

Item 1 Main

 

Step 2

Next grab a copy of our template from the download section or Here

This contains the correct column headers we require for the information. They also give the corresponding column letters from the JLP Connect Spreadsheet.

Then move onto step 3.

 

Item 1 Main

 

Step 3

Now copy and paste the information from your JLConnect file into the template we have provided for you.

Please ensure extra care is taken when pasting the data into the respective column. Now move onto step 4.

 

Item 1 Main

 

Step 4

Please review all of the information in the file. Do not add any extra formatting, colours or pictures etc. We only require the basic text information. Any other data could cause problems with your order, which could lead to a delay. Next move on to the final stage

Please notice the address column in the above example. If no data is required in the listed columns, then please do not add anything. Leave these columns blank

 

Item 5 Main

 

Final Stage

Now please export the file as a comma delimited CSV file.

To do this, choose:

FILE -> SAVE AS -> OTHER FORMATS

Then in the bottom dropdown box, choose CSV Comma Delimited.

All we require you to do is email this file to us with your order.

Please Add the following to your covering email:

 

  • Description of Complete Order
    		•
  • Label Dimensions Required
    		•
  • Delivery Address If Different
    		•
  • Packing Information (number per roll, fanfolded etc)
    		•

     

     

     

    A Database template can be downloaded below.

    Please use this for your data. Do not include formulae. Only include the raw data. Also - do not attempt to change the headers or add data outside the range. These cells have been locked to help you see the region of data required.




    Download Here