Skip to content
Try free for 14 days

Supplier feed sync

A file from a URL or a Google Sheet checked on a schedule, with automatic saving up to a change threshold.

Does your wholesaler publish a file with prices and stock at a fixed URL? WooMate fetches it on a schedule, checks it with a dry run and prepares the changes. It can save small price and stock changes on its own.

What you need first

  • A plan with Import: Pro, Pro Lifetime or Agency, or the free trial.
  • A direct HTTPS link to a CSV or XLSX file that opens without logging in. It can also be a Google Sheet URL. WooMate reads a private sheet through your connected Google account.
  • SKUs in the file and in the store. WooMate identifies products by SKU.

How to add a source

  1. Open Import and choose Wholesaler sync.
  2. Click Add source, then fill in Name and File URL.
  3. Click Read file and match the columns as in a regular import. You can set a price rule, row filter and products not in the file.
  4. Choose what to do with products from the file: update only or update and add new products.
  5. Set the schedule: every hour, or every 6, 12 or 24 hours.
  6. Decide on automatic saving and click Save source.

The first check starts within a minute. Check now runs it right away.

What happens at each check

  1. WooMate fetches the file and runs a dry run, the same as in a regular import.
  2. It marks products that already have the file's values in the store as Unchanged.
  3. If there are changes, it either saves them on its own or leaves a Wholesaler import waiting for approval task on the Overview screen. The task takes you to the dry run result with a save button.

Automatic saving

By default, every change waits for your approval. When you check Save price and stock changes automatically up to …%, WooMate saves the changes on its own. Set the threshold in Largest price change without approval (%): from 1 to 100%, 30% by default. Automatic saving works only when:

  • no price (regular or sale, including in variations) changes by more than the set percentage,
  • the file has no new products or variations,
  • there are no more than 5 products outside the file to mark as out of stock, or 10% of the products in the file (whichever is larger),
  • no item needs checking.

Otherwise, all changes wait in the task with the reason, for example “12 prices change by more than 30%”.

Automatic saving changes only the fields matched in the source. Stock has no threshold: if the wholesaler zeroes out stock in the file, WooMate saves it. Before you turn this on, review a few runs with approval.

Limits

  • Files up to 10 MB, CSV or XLSX. XML and FTP aren't supported.
  • Up to 10 sources per store.
  • If another import is running in the store, the check moves back by 5 minutes.
  • WooMate retries a failed check after an hour and leaves a task with the error on the Overview screen.
  • WooMate spends at most 30 seconds fetching a file from a URL.

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