Categories
View Replies (3)

Resolved import multiple prices at once from CVS

  1. dundscom
    dundscom
  2. RO CSVI
  3. Tuesday, 17 January 2017
  4.  Subscribe via email
* Version of the extension you are using: Virtuemart 3.0.18.3
* CSVI version: 7.0.1

Hello, first of all thank you for CSVI!
I needed to import multiple prices at once from CVS:
"product_sku";"price_quantity_start1";"price_quantity_end1";"product_price1";"price_quantity_start2";"price_quantity_end2";"product_price2";"price_quantity_start3";"price_quantity_end3";"product_price3";

have you any idea?
0
Responses (3)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Have a look at import VirtueMart prices document to know more on price import. CSVI will process values with multiple rows so you should have your CSV file in the format below

"product_sku1";"price_quantity_start";"price_quantity_end";"product_price"
"product_sku2";"price_quantity_start";"price_quantity_end";"product_price"
"product_sku3";"price_quantity_start";"price_quantity_end";"product_price"
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
dundscom
dundscom
Accepted Answer Pending Moderation
Hello,
Have a look at import VirtueMart prices document to know more on price import. CSVI will process values with multiple rows so you should have your CSV file in the format below

"product_sku1";"price_quantity_start";"price_quantity_end";"product_price"
"product_sku2";"price_quantity_start";"price_quantity_end";"product_price"
"product_sku3";"price_quantity_start";"price_quantity_end";"product_price"


Thank you for your prompt reply i would like to clarify, i have two products (apple and banana) with multiple price ranges.
------------------------
1 apple cost 5€, 2 to 5 apples cost 3€, 6-10 apples cost 2€
1 banana cost 2€, 2 to 10 bananas cost 1€, 10-999 bananas cost 0,5€

My CSV:
"product_sku";"price_quantity_start1";"price_quantity_end1";"product_price1";"price_quantity_start2";"price_quantity_end2";"product_price2";"price_quantity_start3";"price_quantity_end3";"product_price3";
apple;1;1;5€;2;5;3€;6;10;2€;;;;
bannana;1;1;2€;2;10;1€;10;999;0,5€;;;;
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
My CSV:
"product_sku";"price_quantity_start1";"price_quantity_end1";"product_price1";"price_quantity_start2";"price_quantity_end2";"product_price2";"price_quantity_start3";"price_quantity_end3";"product_price3";
apple;1;1;5€;2;5;3€;6;10;2€;;;;
bannana;1;1;2€;2;10;1€;10;999;0,5€;;;;

Your CSV should be having prices in multiple rows like below. Please check the linked document in my previous post. There are examples explained in the document too.

"product_sku";"price_quantity_start";"price_quantity_end";"product_price"
"apple";"1";"1";"5"
"apple";"2";"5";"3"
"apple";"6";"10";"2"
"banana";"1";"1";"2"
"banana";"2";"10";"1"
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
  • Page :
  • 1


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