Create compare at price for one location

Shopify Discussion
,
1

Initial situation:

  • We have two warehouses (two locations in shopify terms)
  • Warehouse A sends to EUROPA incl. Switzerland
  • Warehouse B only sends to Switzerland
    • they both share the market Switzerland
  • We currently only have a selling price per market in the system (no compare at price)

Goal:

We want to sellout warehouse B with a nice discount that is visible through a compare-at-prize.

What needs to be done:

  • move prize to compare at prize ONLY for this specific market
  • automatically create a 30% discount ONLY for this market, ideally prizes get rounded to look nice

Looking for:

Is there an app, workflow or another way to do this and also to revert it easily once the warehouse B has been sold out?

I do not feel comfortable doing this with export/import.

Thank you for your help.

2

If you have a separate Market, you can create a catalog with a pricelist for this market and add these products with discounted prices there.
This way everybody will see normal prices, but Swiss market will see discounted prices.

This can be done with Flow – loop over your products, find those stored at warehouse B and add a pricelist entry for them.

Then you’d probably need to monitor inventories and as soon as product is sold out at Warehouse B, remove the relevant entry from pricelist so that Swiss market can continue buying this product from main warehouse at normal price.
Again, can be done with Flow.

When warehouse B is closed, simply remove pricelist from the Swiss market (or it will already be empty because of the inventory monitoring flow).

3

Thank you for this great input. Are you doing this kind of work by any chance? Would you like to do this for us?

Unfortunately, this has to be ready until Wednesday, and I am missing the time to look into Flow.