VirtueMart Forum

VirtueMart 2 + 3 + 4 => Product creation => Topic started by: biker_bits on July 11, 2014, 09:27:42 AM

Title: SOLVED: Products not shown after CSV import
Post by: biker_bits on July 11, 2014, 09:27:42 AM
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]
Title: Re: Products not shown after CSV import
Post by: GJC Web Design on July 11, 2014, 10:54:23 AM
csvi is a well supported 3rd party extension witha very active forum - I'm sure they will help you there
Title: Re: SOLVED: Products not shown after CSV import
Post by: biker_bits on July 14, 2014, 18:34:22 PM
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]