Categories
View Replies (9)

Resolved Items imported with CSVI not publishing

  1. WhiteCastlePtyLtdAdmin1
    WhiteCastlePtyLtdAdmin1
  2. RO CSVI
  3. Saturday, 28 March 2015
  4.  Subscribe via email
Joomla 3.4.1
Virtuemart 3.0.6.4
CSVI Pro 5.21.1
PHP 5.3.29

Imported items with CSV file written with OpenOffice format UTF-8.
Imported successfully with all specified fields filled and published set at 1. Joomla back end admin registered the items, but they do not show on the front end web site.
As a control, I made another item from Joomla admin and populated the same fields and categories. The item shows up on the web site.
The categories were set up with Joomla admin, not via CSV.
I have attached the CSV import file in case I have left anything out.
I have tested importing a dummy part (see file). What happens is that during importing a parallel (virtual?) category is created (and set as published) instead of the item being imported into the Virtuemart created category.
In Virtuemart back end, there are two Global categories. instead of only the one which I manually created.
In other words, the CSV created categories do not publish.
0
Responses (9)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

I will need the debug log, as requested at the top of the page, to have any idea what happens during your import. Please post your debug logs and I will check what happens.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
WhiteCastlePtyLtdAdmin1
WhiteCastlePtyLtdAdmin1
Accepted Answer Pending Moderation
Added Debug File
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

The debug file did not attach. Make sure you are uploading a zip file and not a php file.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
WhiteCastlePtyLtdAdmin1
WhiteCastlePtyLtdAdmin1
Accepted Answer Pending Moderation
Debug log file attached.
Attachments (1)
com_csvi.log.1427718793-2.zip
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Looking at the debug log I do see that the products are being set to published. 
UPDATE `wya_virtuemart_products` SET `virtuemart_vendor_id`='1',`product_parent_id`='0',`product_sku`='G-TEST',`product_weight`='1',`...,`layout`='0',`published`='1',... WHERE `virtuemart_product_id`='266'
So this leaves us with a few options. If you are using SEF, do you see the same issue when SEF is off? If you are using cache, do you see the same issue when cache is off? Let's check that first.

The product is there as you can see it in the backend, so just need to see why the frontend won't show it.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
WhiteCastlePtyLtdAdmin1
WhiteCastlePtyLtdAdmin1
Accepted Answer Pending Moderation
I have tried all the permutations of SEF on / off and cache off/ on. The same issue remains.
This issue seems to be confined when a new item is uploaded onto the site. If an existing item is modified, for example stock level, there is no issue.
If importing a new item via CSV with a category path, a virtual category of the target category is created, flagged as published but does not display, neither the item nor the virtual category. The back end shows the new category and item as published.
Attached are the debug logs and a text file showing the procedures and the results.
Cache handler set to "file".
Attachments (8)
GlobalTEST-2.csv
Debug-5APR2015-WhiteCastle.txt
com_csvi.log.1428228066.zip
com_csvi.log.1428228575.zip
com_csvi.log.1428228847.zip
com_csvi.log.1428229105.zip
com_csvi.log.1428229420.zip
com_csvi.log.1428229646.zip
  1. more than a month ago
  2. RO CSVI
  3. # 6
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Can you sent me a private message with the URLs and login details for the website, FTP and database? I will take a look for you to see why they don't show up. Nothing stands out in the debug log, especially since you see the products in the shop itself I don't think there is a problem with the import. If it would be an import problem, more people would have the issue.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
WhiteCastlePtyLtdAdmin1
WhiteCastlePtyLtdAdmin1
Accepted Answer Pending Moderation
Upgraded to Virtuemart version 3.0.8 and it has so far fixed this issue.
  1. more than a month ago
  2. RO CSVI
  3. # 8
WhiteCastlePtyLtdAdmin1
WhiteCastlePtyLtdAdmin1
Accepted Answer Pending Moderation
Solved
  1. more than a month ago
  2. RO CSVI
  3. # 9
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!