Categories
View Replies (3)

Resolved product Price

  1. Julius.Piwowar
    Julius.Piwowar
  2. RO CSVI
  3. Monday, 19 October 2015
  4.  Subscribe via email
VM 3
Joomla 3.4
CSVI Pro

Hey Rolandd,

I am having problems to import new products including a price. A couple days ago, with other products, it worked but now I am receiving an error. Would you please translate the error?

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `product_currency` = 47 AND `product_price_publish_up` = '0000-00-00 00:00' at line 3 SQL=SELECT `virtuemart_product_price_id` FROM `aw2hd_virtuemart_product_prices` WHERE `virtuemart_product_id` = 461 AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND `virtuemart_shoppergroup_id` IS NULL) AND `product_currency` = 47 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00' Thanks!!
0
Responses (3)
Julius.Piwowar
Julius.Piwowar
Accepted Answer Pending Moderation
I am using product_sku and product_price
  1. more than a month ago
  2. RO CSVI
  3. # 1
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Julius,

See this announcement SQL error on price import.
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. # 2
Julius.Piwowar
Julius.Piwowar
Accepted Answer Pending Moderation
worked! Thank you!!
  1. more than a month ago
  2. RO CSVI
  3. # 3
  • Page :
  • 1


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