Resolved Volume discount import

Hello Ivo,

You can't combine these fields indeed because price_quantity_start and price_quantity_end are really price fields and not product fields. So the only way to do that would be to export these values using the price export and import them using the product import. During import you would link the price_quantity_start, price_quantity_end and product_price to the custom field you want to use.

That is how I see it work.

Sounds good !

So i started with your solution
I have done te export and it looks like this

Artikelcode StartStaffel EindStaffel Prijs
3053410 50 0 3.10
3053410 10 49 3.25
3053410 1 9 3.60

The Artikelcode collumn is the product_sku
And there i get confused

How to import 3 rows in the same SKU at different custom fields ?

StartStaffel = price_quantity_start
EindStaffel = price_quantity_end
Prijs = product_price
(although i believe your understand dutch )

any suggestions ?

Hello,

How to import 3 rows in the same SKU at different custom fields ?

Let me turn this question around. How were you planning to store the staffels in the custom fields? In other words, how would you do it manually? Perhaps ask why do you want the staffels in custom fields?

Oke..
fair question..

What i want to do is the following :

Make a 3 custom fields
Start_Staffel1 , End_Staffel1, Price_staffel1
And for the next discount Start_Staffel2 , End_Staffel2, Price_staffel2
And last Start_Staffel3 , End_Staffel3, Price_staffel3

So in total 9 custom fields.
I only need / have 3 levels of discount.

I want them in the custom fields because VM does make it possible to set up prices like so and it works.
But displaying this table is default not possible (strangly enough)

If i can copy these values in a custom field then i can display what i want where i want it.

That is the reason

Hello,

Weird that you can't display a table of discounts. To go back to what you want to achieve, the output of the price export is this:

Artikelcode StartStaffel EindStaffel Prijs

3053410 50 0 3.10

3053410 10 49 3.25

3053410 1 9 3.60

To import this you are going to need to reformat it as:

product_sku,Start_Staffel1,End_Staffel1,Price_staffel1,Start_Staffel2,End_Staffel2,Price_staffel2,Start_Staffel3,End_Staffel3,Price_staffel3

3053410,50,0,3.10,10,49,3.25,1,9,3.60

This way you can import them all in one go. If you run the Update from the Available Fields after creating the custom fields you should see these fields available.

The only problem I see here is that you need to transpose the data, that is not easy.

Thinking out loud what may work is a format like this:

product_sku,custom_title,custom_value

3053410,Start_Staffel1~End_Staffel1~Price_staffel1,50~0~3.10

3053410,Start_Staffel2~End_Staffel2~Price_staffel2,10~49~3.25

3053410,Start_Staffel3~End_Staffel3~Price_staffel3,1~9~3.60

I haven't tested this but you could give it a try. With some imagination you could have the export produce this format I think.

The other option is also of course to make a template override of the VirtueMart view and write some code to retrieve the prices from the database and display them in a table as you wish.