I have been using cpanel to import and export products in the database. I've successfully imported 12000k products so far. Recently I tried to import 800 new products and for some reason, only 28 will show up in the actually store. When I check the database through cpanel, all information is in the oc_products and respective databases, but they dont actually show up in admin or store (except for 28 products). I've tried a category repair, vwmod flush and checked the date in the database but the new products just wont show up. Anyone have any thoughts?
1.5.6.4
www.sloopysaz.com
Hi flywatches,
without access to your database, it's hard to give a clear answer.
If you want to give me access, PM me the details and I'll write some queries to work it out for you.
Otherwise, go through the queries in the "admin\model\catalog\product.php" file and see that you've executed all the relevant ones. Something as simple as missing the product to store mapping could hide your products.
- Mel
without access to your database, it's hard to give a clear answer.
If you want to give me access, PM me the details and I'll write some queries to work it out for you.
Otherwise, go through the queries in the "admin\model\catalog\product.php" file and see that you've executed all the relevant ones. Something as simple as missing the product to store mapping could hide your products.
- Mel
http://online.enterpriseconsulting.com.au
Site with OpenCart extensions & code downloads, many new extensions coming soon!
Follow us on twitter for more updates
It turned out to be a very simple issue. I went back through all of the product import files and found the issue. Upon copying and filing, I missed dragging the correct language (1) under oc_product_description.csv and so the products were not showing in our store or admin since it is setup in English.
Jonathan
Who is online
Users browsing this forum: Bing [Bot] and 109 guests