Please submit a private ticket if you need to share sensitive information, such as license details and admin credentials.

Okay
  Public Ticket #3784544
importing bulk prices and quantity step for variations
Open

Comments

  •  1
    Razvan started the conversation

    i have lots of products with lots of variations. how can I import a table (knowing the ID of the variation) containing:

    - normal price

    - min quantity for price 2

    - price 2

    - min quantity for price 3

    - price 3


    after import i would like to have all the target quantities and prices set for each variation. 

    Thanks

    Attached files:  Screenshot 2024-12-16 at 17.50.31.png

  •  1
    Razvan replied

    Any help wpclever?

    We need to import prices and minimum quantities for hundreds of variations. How can we do this bulk?

    It is not right to edit every variation manually. 

  •   Razvan replied privately
  •  1,355
    Dustin replied

    Hi Razvan,

    I'm so sorry for the late reply! I must have overlooked your ticket :(

    Unfortunately, our plugin doesn't have the feature to import pricing tables like that. To easily add a pricing table for multiple variations, try using a free plugin: https://wordpress.org/plugins/wpc-variation-bulk-editor/ 

    Best regards,
    Dustin

  •  1
    Razvan replied

    Hi Dustin,

    The thing is your plugin generates in the export file something like this:


    Meta: wpcpq_prices
    {"tf3e**0":{"role":"0","apply":"all","apply_val":"","method":"volume","layout":"default","tiers":[{"quantity":"6","price":"3639.45","text":""},{"quantity":"12","price":"3546.92","text":""}]}}

    I see there I can modify the steps and price for that variation and then import them back and it works. 

    But your plugin gives an ID to each variation too: ex: "tf3e**0" which makes it impossible to just make a csv with information and import. ex: (step1,price1,step2,price2,etc).

    Why dont you just map the information with the variation ID?

    Then we would be able to import something like this:

    {"role":"0","apply":"all","apply_val":"","method":"volume","layout":"default","tiers":[{"quantity":"6","price":"3639.45","text":""},{"quantity":"12","price":"3546.92","text":""}]}

    I will try to use the plugin you mentioned just to generate the steps for all variations with fake data and then export, modify and import back with real data.

    It would be very very nice to be able to import as a csv all that information.

    Thank you for your reply and idea,

    Razvan

  •  1,355
    Dustin replied

    "tf3e**0" is a random key; you can replace it with any 4-character word. Just remember to choose different keys in one wpcpq_prices data. For example:

    7346155223.png

    Best regards,
    Dustin

  •  1
    Razvan replied

    Thank you.

    So the random key has to be unique with each import i make?

    Or it has to be unique on the entire website (like IDs are?)

  •  1,355
    Dustin replied

    It only needs to be unique for wpcpq_prices in each product/variation. You can use the same key for another product in the import file.

    Best regards,
    Dustin