Dynamic prices based variations

  • Resolved hassanayoub85

    (@hassanayoub85)


    2 years, 7 months ago

    Hello,

    I have an excel pricelist of 2 variations A columns and B rows where different values between A[x] and A[y] and B[x] and B[y] .

    Example:

    from A0 to A9 and B0 to B9 the price is 1

    from A10 to A19 and B0 to B9 the price is 2

    from A0 to A9 and B10 to B19 the price is 3

    from A10 to A19 and B10 to B9 the price is 4

    Any idea how to achieve that?

Viewing 1 replies (of 1 total)
  • Plugin Support Shameem – a11n

    (@shameemreza)

    2 years, 7 months ago

    Hi @hassanayoub85

    WooCommerce does not directly support importing from Excel, but you can achieve this by using a plugin such as “Product Import Export for WooCommerce” or “WooCommerce CSV Import Suite.”

    You’ll need to convert your Excel file to a CSV file first. Then, you can map the columns in your CSV file to the appropriate fields in WooCommerce.

    For your specific price variations, you can create a CSV file with columns for SKU, Regular Price, and Sale Price. For each variation (A0 to A9, B0 to B9, etc.), you would have a separate row in the CSV file with the corresponding price.

    Once your CSV file is ready, you can use the plugin to import it into WooCommerce. Please make sure to back up your site before importing or making changes to your product database.

    I hope this helps! If you have any further questions, please don’t hesitate to ask.

Viewing 1 replies (of 1 total)

The topic ‘Dynamic prices based variations’ is closed to new replies.