Help

3

Required CSV import fields and template of CSV files

Avatar
mamak111

When importing products or customers from a CSV file I create a sample exported CSV file from V7. My questions are:

  • 1) Are the required/compulsory fields highlighted in blue?
  • 2) Some fields are not highlighted in blue but when you expand them the sub fields are highlighted. If these sub fields are left out would the data import be compromised?
  • 3) Does anybody have a set of demo import CSV files for importing? I would like to have a look at these so I don't duplicate or end up entering wrong info.
  • 4) What would you recomend be imported? I am importing customers, products and take on balances. Other data will be created, however if you have other import files I would appreciate them as well.
  • 5) If at a later time I do another import using partial fields, will only those fields be updated or will the entire product /customer details be changed. For example I do a stock import ommitting the storage location fields and after a few months I do another import where I change product categories only and add in storage locations.
1 تعليق
الصورة الرمزية
تجاهل
Avatar
ton123
-

I think it is better to split your question (s).

2 الإجابات
14
Avatar
Mario Arias Badila
Best Answer

Hi

I created some templates that were uploaded here

Regard,

5 التعليقات
الصورة الرمزية
تجاهل
Avatar
mamak111
-

Thanks will have a look at them

Avatar
Donald Love
-

Thanks, just wanted to let you know that your answer is helping others, too.

Avatar
Nicholas Burdick
-

Mario, For clarification, are these templates the absolute minimum fields that are required for the records?

Avatar
Mario Arias Badila
-

Hi Nick, not necessarily... We have been creating/collecting them from each client's installation, and it could be possible to remove one or two more...

Avatar
Taat Waluyo
-

Thanks Mario...!!

Your answer is so helpful for others. Thanks for sharing!

0
Avatar
Alex
Best Answer

Great stuff. Thank you for the response, Mario.

الصورة الرمزية
تجاهل