News:

Support the VirtueMart project and become a member

Main Menu

SOLVED: Products not shown after CSV import

Started by biker_bits, July 11, 2014, 09:27:42 AM

Previous topic - Next topic

biker_bits

PHP 5.4.29, Joomla 2.5.2.2, VM 2.6.6, CSVI free 2.15

When importing a very basic file using CSVI, everything seems to import, but products are shown as '0' within categories. All products are correctly listed, with the right stock quantities and descriptions under 'Products'. All products are shown as 'Published'.
However, if I click on 'Show' in the Categories view - products are shown.

One thing i did notice. If a product is edited manually in VM (e.g. stock qty updated), it is then correctly shown within its' category!

I've tried changing data file delimeters to ^ and ~, wiping database, etc. Still no change. I don't think there's a problem with the data file - it's just the processing of what to display seems to be messed up. I must be missing a setting somewhere...
Any hints what to check? I'd rather not use any stock control (product always shown, which is currently selected) or special shopper groups.



[attachment cleanup by admin]

GJC Web Design

csvi is a well supported 3rd party extension witha very active forum - I'm sure they will help you there
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

biker_bits

Solved

Import file seems to require 'published' field, which must be equal to '1' for the product to be displayed.

An example of a working import CSV feed attached. Derived from a CSVI product export - that's how I got the clue as to what's wrong.

Just in case this is helpful to someone...

[attachment cleanup by admin]