Categories
View Replies (9)

Resolved virtuemart_vendor_id not working in import

  1. Fabrizio
    Fabrizio
  2. RO CSVI
  3. Wednesday, 01 March 2017
  4.  Subscribe via email
Good evening we create a template for to permise to our vendor the import in our website with the follow field:
We have 2 problem, the sistem do not publish the price and the product was not assigned to the vendor with the right id
How we can solve?
waiting for your reply
Thanks in Advance
Fabrizio

category_id

product_sku

product_name

product_s_desc

product_desc

manufacturer_name

published

product_in_stock

file_url

file_title

product_price

product_tax_id

product_weight

product_gtin

product_mpn

metakey

metadesc

virtuemart_vendor_id
0
Responses (9)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Fabrizio,
Please post the debug log of the import and sample import file to check. To know how to get debug log, check Where to get the debug information? on top of this page.
Kind regards,

Tharuna

=========================
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
Fabrizio
Fabrizio
Accepted Answer Pending Moderation
Good morning i was sent you by email the debug log, the template xml and the used file for the import,
waiting for your reply
thanks in advance
Fabrizio
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Fabrizio,
Thank you for sending requested details.

We have 2 problem, the sistem do not publish the price and the product was not assigned to the vendor with the right id

You have set Unpublish before import option to Yes on Options tab in your template settings. This setting would unpublish all the products before running the import. You need to set option to No.
Virtuemart vendor id assigned seems to be correct, see the query below from your debug log

INSERT INTO `ilkyf_virtuemart_products` (virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_gtin`,`product_mpn`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES  ('66','0','6546545','5465654','654654','0.250','KG','0','0','0','M','','10','0','0','0','0000-00-00 00:00:00','','0','0','KG','0','min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','1','0','2017-03-01 13:49:01','62','2017-03-01 13:49:01','62','0000-00-00 00:00:00','0')
Kind regards,

Tharuna

=========================
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
Fabrizio
Fabrizio
Accepted Answer Pending Moderation
Thanks Tharuna,
but still not assign to the vendor the product when i import with csvi but just if i create manually.
so i think is pure bug of csvi or perhaps some setting wrong in my template
can u check one more time please?
Did u need account and password of website to check?
if yes please say me...
waiting for you reply
Thanks in advance
Fabrizio
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Fabrizio,

The query that Tharuna posted shows that product with SKU 6546545 is assigned to vendor ID 66. Do you see that vendor assigned to this product? If you don't see that vendor, which vendor is linked to that product?

Out of curiosity, you have 66 vendors in your site?
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
Fabrizio
Fabrizio
Accepted Answer Pending Moderation
Hi yes we have 66 vendor id
and the product was assigned to the admin
  1. more than a month ago
  2. RO CSVI
  3. # 6
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

and the product was assigned to the admin
I am afraid I don't understand what you mean here. In the database the product is assigned to vendor ID 66. When you edit the product, you see another vendor selected? Perhaps you can post a screenshot of what you see.

On my local system I changed the vendor to a different one and the product showed me the different vendor.
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
Fabrizio
Fabrizio
Accepted Answer Pending Moderation
As you can see in the screenshot after the import on the vendor 66 FABRIZIO COLAVINCENZO in the panel admin virtuemart if u do no select any vendor the product results, but if you select FABRIZIO COLAVINCENZO the product was not import there
Attachments (2)
Screenshot 2017-03-05 16.40.02.png Screenshot 2017-03-05 16.40.02.png
Screenshot 2017-03-05 16.40.14.png Screenshot 2017-03-05 16.40.14.png
  1. more than a month ago
  2. RO CSVI
  3. # 8
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

When you open the product, what do you see there in the vendor box?
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. # 9
  • Page :
  • 1


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