EXPORT IMPORT Products

Store Builder Questions
1

Hello,


  • I “exported” Demo products using “general” layouts into CSV format.


  • 2 lines on top of this CSV file deleted
  • First 10 product + header line (11 lines alltogether) copied into a new CSV file named test.csv
  • code value only is modified for 10 products
  • File saved as CSV.
  • File closed
  • Attempting to “Import” this file returns the error :

[QUOTE] Your CSV file has incorrect data formatting (incorrect delimiter, missed fields, etc.) on the following lines: 2, 3, 4, 5, 6, 7, 8, 9, 10, 11

[/QUOTE]





BUT repeating the same operation exporting only 3 fields:

[QUOTE]Product code Product name Description[/QUOTE]



And using the very same above way to Import that file:

All products are created (obviously these 3 fields only) in a category " Products"

NO ERROR…



What am I doing wrong?

2

[quote name=‘aerofan’]What am I doing wrong?[/quote]



Not searching the forum :wink:

[url]http://forum.cs-cart.com/showpost.php?p=54938&postcount=9[/url]



Which is part of the parent thread:

[url]http://forum.cs-cart.com/showthread.php?p=54938#post54938[/url]

3

You are right!:oops:



Thanks it works!

4

After this and later updating using the official (ZEKE) fix, it worked OK for a while.



Today I cannot import even one single product.



After “Downgrading” again using “Tool Outfitters” fix: 15 products only are imported in one shot.



No mods made.

Cache is empty



Any idea someone?

5

There are still problems with import. I have spoken to CS about it and supposedly they are working on it.



Are you getting any errors?



One of the many reasons I haven’t made the move to 2.x.

6

Using “Zek” mod the “orange” color pad says:


[QUOTE]Your CSV file has incorrect data formatting (incorrect delimiter, missed fields, etc.) on the following lines: 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51 [/QUOTE]



Using “Tool Outfitters” mod the “orange” color pad says:


[QUOTE] Your CSV file has incorrect data formatting (incorrect delimiter, missed fields, etc.) on the following lines: 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68

Warning

Close

Data is imported successfully.

New objects - 15;

Updated objects - 0;

Skipped objects - 0;

Total - 15.

[/QUOTE]



The next 15 products will be successfully imported after deleting lines 2-16 in CSV file … and so on.

7

Not sure what to tell you. Like I said, they are supposedly working on it.

8

Thanks for your help.

I noticed bug tracker got a “fixed” status.



I found a small part of the solution:



Last field of Excel row (secondary categories), in my case, had a blank cell, on every line.



Filling cells at rows 17, 33, 49, 65, 81, … with text datas solves the problem for “Tool Outfitters” version.

Filling cells for every row is also OK.

( Beside it obviously creates corresponding “secondary categories” and links corresponding products)



I successfully imported 479 products in 2 different languages.



Problem remains the same when using “ZEKE” official fix. (not a single product can be imported).

9

Yep, that’ll do it too. If you have all blank cells under a field, it’s best just to leave the field out all together.

10

Got it.

Should you have products having no “secondary categories” would you recommend creating a “useless” hidden category for these?

11

No, that’s too much trouble. You can have blank cells (you will still get warnings). Just make sure that the last column doesn’t have blank cells or else it may give you problems.



It’s time consuming but you could import 1 field at a time and delete any blank cells you have.