importing inventory items into pastel

[Kaveet]

There were a number of errors with your CSV file.

Firstly, you need to delete the heading row.

You only had three selling price columns, instead of 10. Even though Xpress only provides for 3 price lists (whereas Partner provides for 10), you still need to have all 10 columns in the CSV file.

You only had one column for the user defined text fields, instead of 3. The same applies to the user defined numeric fields.

The last four columns were displaced from from the 4th last heading, i.e. Commission Item.

I have fixed the errors and attached the modified CSV file. I have left the heading row in so that you can see what I have changed, but you must delete that row before you save the file and import it. Also, you will need to reformat the Group, Category and Store data cells.

Hi Neville, please also send me the import document u send blueboy

[Neville Bailey]

Hi Neville, can you please send me a copy of the import document u edited for blueboy

You can download the document from post #8.