Import Products table into AC7 database

[sohaib]

The ac_Products table has a categoryID field.

A product can be in multiple categories so a single category Id is not sufficient to hold this information. I went back to check the database in order to see if there really is a categoryID field in ac_Products table. There isn't.

[Naveed]

Didn't notice this until now, but the 95% of the Name field rows have commas:

NOW L-Carnitine, 500 mg, 180 caps

I guess this won't work:

Code: Select all

Name,Price,MSRP,Manufacturer,Sku,Description,Categories
Product1,24,23,ABC manufacturers ltd.,SKU232,Description of the product1,My Category
.............

I would need to change the text delimiter but not sure how to do that right now.

You can either change the text delimiter or use the same text delimiter (i.e. comma) with appropriate text qualifiers.

Here is an example that how you can create the CSV data with double quoted ["] text qualifier:

Code: Select all

"Name","Price","MSRP","Manufacturer","Sku","Description","Categories"
"Product1, papers, printers","24","23","ABC manufacturers ltd.","SKU232","Description of the product1","My Category"
"NOW L-Carnitine, 500 mg, 180 caps","34","33","ABC manufacturers ltd.","SKU2df3","Description of the product2","My Category"
"Product3, Flowers and Gifts","22","20","ABC manufacturers ltd.","SKU2dfc","Description of the product3","My Category2"
"Product4","45","44","ABC manufacturers ltd.","SKU2343","Description of the product4","My Category3" 

Note the comma in product names ....

[Mike718NY]

thanks Naveed, this is going to save me a lot of problems.

I just found out that I can change the default text delimiter in Excel to a Pipe (|).
For anyone interested, here's how:
Start -> Settings -> Control Panel -> Regional Settings
"Number" tab, . . in the "List Separator" field, replace the current default separator

Excellent, now I can proceed using the DataPort.

One question:
Do I make that first line ("Name","Price","MSRP", . . ) in the .csv file myself?

"Name","Price","MSRP","Manufacturer","Sku","Description","Categories" <<<
"Product1, papers, printers","24","23","ABC manufacturers ltd.","SKU232","Description . .

Do I just open Excel and add that as the first row in the .csv file?

[jmestep]

Yes.