HomeHome Product Discus... Product Discus...SmithCartSmithCartImport / Export products questionImport / Export products question
Previous
 
Next
New Post
7/14/2014 8:52 AM
 
Hi 
I have about 1600 products on one of my carts and when Exporting my Products I would like to use the same Excel sheet to upload them after making changes.
Can someone please tell me what value I must enter into the 'DELETE' column of the xls file for it to delete the product from the shopping cart? Without having to do so manually.

Thanks
Steve
 
New Post
7/14/2014 4:23 PM
 
Hi Steve,

To delete a Product with the Product Import, enter the letter "y" in the delete column of the spreadsheet before you import. This will logically delete the Product. Products are never actually deleted from the products table. There is a bit field called "LogicallyDeleted" that is set to 1 when you delete a product then the manage products screen filters for records where logicallydeleted != 1.

If you want to delete the logically deleted records you can issue the following sql script:

delete * from smith_products where logicallydeleted = 1

Hope this helps!
 
New Post
7/23/2014 5:30 AM
 
Hi Kevin

I tried adding a 'y' into the Delete field and it didn't work, I can still see the products i deleted.
Also I am sharing all my products between 2 cart instances on the same portal (one with prices one without). When exporting making changes and re-importing the list, about 120 of the products don't share anymore (I had to run a SQL script to change the SHARE from 0 to 1) This is all fine, but my client doesn't have access to my SQL server and they do weekly uploads. Please advise.

Regards
Steve
 
New Post
7/24/2014 1:09 PM
 
Any news on this problem?
 
New Post
7/27/2014 12:23 PM
 
Hi Steve,

When you say that you can still see the products you deleted, do you mean that they are still being displayed on your Product Listing page or that they are listed on the Manage Products screen?

Just to let you guys know, if you ever have any sort of problem like this, please start a support ticket with us. Starting a ticket ensures that you will get the problem looked into immediately. These forums are meant mostly for community discussions, and not as a means of technical support. Often, like this thread, it can go a while without an answer, due to how random our visits to the forums are. I personally check in whenever I get a chance, but usually it's 5 minutes here, 5 minutes there, and I end up missing or overlooking important threads.

Thanks!
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartImport / Export products questionImport / Export products question