Skip to content
Try free for 14 days

Price rule, row filter and products not in the file

How to recalculate prices from a wholesaler file, import only selected rows and mark missing products as out of stock.

These three settings sit in the File step, below column matching. They're saved together with the column layout, so the next file with the same headers gets them right away. They also work in supplier feed sync.

Price rule

Recalculates the Price and Sale price from the file, including in variations. It appears once you match a price column.

  1. Expand Price rule and check Recalculate prices from the file.
  2. Choose a method: Markup, Margin or Discount off the file price, and enter a percentage.
  3. Enter Your wholesaler discount (for markup and margin) and VAT.
  4. Say whether the Price in the file and the Price in the store are Net or Gross.
  5. Choose Rounding: To the cent, Up to .99 or Up to whole dollars.

The example below the fields updates live for a price of $1,000. With a 25% markup, no wholesaler discount, 23% VAT, a net price in the file, a gross price in the store and rounding up to .99, you'll see “$1,000.00 in the file → $1,537.99 in the store”. If the sale price isn't lower than the regular price after recalculation, the product goes on the problem list.

Row filter

Import only rows that… skips rows that don't meet your conditions, for example only the “Boilers” category or stock greater than 0.

  • Up to 10 conditions. All of them must be met.
  • Conditions: equals, does not equal, contains, does not contain, is greater than, is less than, is empty, is not empty.
  • A counter shows how many rows the filter will skip. Skipped rows aren't problems and don't break up variations.

Products not in the file

Available with the Update prices or stock and Add new and update existing goals. Mark products missing from the file as out of stock covers products in the chosen scope that are in stock today.

  1. Expand Products not in the file and check the option.
  2. Enter an SKU prefix (for example WHOLE-), choose a Category, or both. You can't turn the option on without a scope, so it never changes your whole store.
  3. The check shows a Not in file tile with examples.

Products with stock tracking get 0 units, the others get the “out of stock” status. The scope can cover up to 3,000 products and variations. If it's larger, narrow it with an SKU prefix or a category.

Can't find the answer? Write to hello@getwoomate.com or request free onboarding help.