Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Help to delete all items in Catalog, Upload new catalog


gregwee

Recommended Posts

I've tried searching the forum but so far, haven't found anything.

 

I need some tips on what's the easiest way to get rid of all items in the catalog/inventory instead of individually deleting each item/category in admin. In addition, does anyone have sql to use an excel spreadsheet in csv/tab format to upload a completely new catalog/inventory into the system. Does anyone have the details on what tables/fields need to be deleted/populated in the database?

Link to comment
Share on other sites

I've tried searching the forum but so far, haven't found anything.

 

I need some tips on what's the easiest way to get rid of all items in the catalog/inventory instead of individually deleting each item/category in admin. In addition, does anyone have sql to use an excel spreadsheet in csv/tab format to upload a completely new catalog/inventory into the system. Does anyone have the details on what tables/fields need to be deleted/populated in the database?

This might be what you need to clear the DB

 

If you want to use CSV to add products search the contributions for Easy Populate (that's what most use)

If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you.

 

"Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice."

- Me -

 

"Headers already sent" - The definitive help

 

"Cannot redeclare ..." - How to find/fix it

 

SSL Implementation Help

 

Like this post? "Like" it again over there >

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...