Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Help Importing Large Inventory


Guest

Recommended Posts

Posted

I've tried using a couple of the Contributions that promise Easy Population of a vast inventory, but to no avail - none of them are easy. I'm way behind in my project now, and am hoping that there is someone who can offer me some assistance in this...

 

...about 1000 items... there's no way i can manually input them.

 

 

 

*** i have an xls file that i created to coincide with the products and products_description tables and successfully populated these database tables this way, but the items aren't showing up in OSC - i'm obviously missing some tables and i realize that tracking down all the tables that are necessary would be very tedious. any help...?

 

thanks for any help you can give.

 

Glenn Nall

Posted

thanks - got products_to_categories populated, still nothing shows up in the website - that's

 

products

products_descriptions

products_to_cat.

 

is there anything anyone can see i've missed i've missed?

 

 

 

 

 

 

you need to populate the products_to_categories table as well. That way your products know where to show up :). If you have no categories configured you should do that first.
Posted

thanks, Jeff, i figured it out - had to change language_id and products_status values to 1...

 

thanks for your help...

 

it's a shame Easy Populate ISN'T.

Posted

good you've loaded up your stuff, however EP is handy later on to quickly scann the data in your shop or focus on certain categories and/or manufacturers. I strongly advise to try to get EP setup so you have an easy way to do batch updates. For me it has been a real time saver.

KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Archived

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

×
×
  • Create New...