Categories
View Replies (53)

Resolved Big file, no prices after import

  1. kelecz
    kelecz
  2. RO CSVI
  3. Thursday, 12 February 2015
  4.  Subscribe via email
Dear R.

a split 5700 row file on 3 files and it work. But there is no prices and consequently there is no add cart button.
I have to repeat when I import 10 row test file everything was fine.
Second thing is that "Append categories" function is not working. It add more categories on

Please advice.

J 336
VM 204
CSVI 520 pro
    
0
Responses (53)
kelecz
kelecz
Accepted Answer Pending Moderation
And this is interesting: if I not import image urls I can se prices and add to cart btn.

See pict:


2015-02-1611-27-20.png
Attachments (1)
2015-02-1611-27-20.png 2015-02-1611-27-20.png
  1. more than a month ago
  2. RO CSVI
  3. # 41
kelecz
kelecz
Accepted Answer Pending Moderation
Thank you R.,

I empty sql and import file.

Here is log file.


com_csvi.log.1424081939.zip
Attachments (1)
com_csvi.log.1424081939.zip
  1. more than a month ago
  2. RO CSVI
  3. # 42
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Post me the new debug with the Overwrite data option set to Yes, without this log I can't help.

The salesprice in your import file is not used by CSVI.
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. # 43
kelecz
kelecz
Accepted Answer Pending Moderation
This is export file if can help....


product_export.csv
Attachments (1)
product_export.csv
  1. more than a month ago
  2. RO CSVI
  3. # 44
kelecz
kelecz
Accepted Answer Pending Moderation
Yeah, mistake. but no prices in VM products module...
http://www.petproba.konji.rs

In original install option with his show up products in US dollars it was ok. Not know what to do...
  1. more than a month ago
  2. RO CSVI
  3. # 45
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

It doesn't do anything because you have set Overwrite existing data to No. Of course nothing happens because you tell CSVI not to touch existing products. You will have set this to No if you want to update your products.
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. # 46
kelecz
kelecz
Accepted Answer Pending Moderation
May be.

This one is minute ago. Hope you see something. If you want, can give you admin privileges.


com_csvi.log.1424027431.zip
Attachments (1)
com_csvi.log.1424027431.zip
  1. more than a month ago
  2. RO CSVI
  3. # 47
rolandd
rolandd
Accepted Answer Pending Moderation
The log file you posted is an empty one. Did you post the wrong one?
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. # 48
kelecz
kelecz
Accepted Answer Pending Moderation
Here is log. No special result. Still no prices.
Attachments (1)
com_csvi.log.1423857546.zip
  1. more than a month ago
  2. RO CSVI
  3. # 49
kelecz
kelecz
Accepted Answer Pending Moderation
Great. Thank you Roland.
Noticu about results.
  1. more than a month ago
  2. RO CSVI
  3. # 50
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

If you have no specific shopper group the shopper_group_name_price field can be set to *.
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. # 51
kelecz
kelecz
Accepted Answer Pending Moderation
Dear R.,

thx for reply. There is no reason. Please tell me which column should add and how to make it functional. Is it "*" or something different?

Thank you in advance.
  1. more than a month ago
  2. RO CSVI
  3. # 52
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Second thing is that "Append categories" function is not working. It add more categories on
That is exactly what this feature is supposed to do. Set this to No unless you know why you need it ;)

That you see no prices has most likely to do with the shopper group because I do see the prices are being added: 
INSERT INTO `jos_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`) VALUES  ('1','0','745','0','152','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','2015-02-12 20:59:36','680','2015-02-12 20:59:36','680')
the shopper group on the other hand is empty. Any reason why you have no shoppergroup?
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. # 53
  • Page :
  • 1
  • 2
  • 3


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