[Resolved] Importing csv file into Store

[bosanci28]

Hello,

So i was trying to upload/import a new csv file to my store and made a backup copy to the database and the exported csv file.

Then i did the import for about 30 items/products and then when i went back to the site,not sure what happen but all my product where gone!.

So based on this picture:

Bellow at those to boxes ,what do i need to check or i don't? 

What i am doing is : updating with new products to my site that don't exists! So i am not updating stock or whatever i have ,all i am doing

is adding new stuff.

So do i check those 2 boxes or no,or one of them?

 

Thanks for any advice.

Regards. 

[bsmither]

Of the two options shown at the bottom of the selectors list, having checked "Replace existing inventory" means that CubeCart will first delete all records (that is, the SQL command TRUNCATE) in the following tables:

            'CubeCart_inventory',
            'CubeCart_image_index',
            'CubeCart_option_assign',
            'CubeCart_reviews',
            'CubeCart_category_index',
            'CubeCart_inventory_language',
            'CubeCart_options_set_product',
            'CubeCart_pricing_quantity',
            'CubeCart_pricing_group',

To insert more inventory while keeping the existing inventory, make sure this option is not checked.

[bosanci28]

So just to clear my self... for adding new inventory (under new categories,new pictures,new items)

CSV has column headers > check box.

Replace existing inventory > do not check box.

 

Thank you!...

Edited August 29, 2015 by bosanci28

[bosanci28]

So every time i add something new, do i need to check box at:

"CSV has column headers" ?

 

Thanks,

[bsmither]

Only if the file has a first row that is not inventory data. For example:

Name, Desc, Price, Sale
Fort, Snow, 10.00, 9.00
Ball, Blue, 11.99, 8.99

This CSV file has a first row that does not have data pertaining to inventory to be added. The first row has 'column headers'. In this case, the checkbox is checked.