Using Clerk.io in Your Store

Sending Sales-Data from POS and ERP systems

See how to upload external sales-data to Clerk.io

For some webshops, it's relevant to upload sales-data from other systems than the actual webshop, for example if you want to opitimise the algorithm based on sales from a physical store, or B2B store.

You can upload the sales in one of two ways:

  • With a CSV file as explained here
  • By creating a Data Feed with a single dummy product (as it's required for the sync) and leave the "categories" lists empty, effectively only sending the "sales" as part of the feed.

An example structure can be seen here:

{
"products": [{"id":1,"name":"Just a dummy product","price":10.00}],
  "categories": [],
  "sales": [{
    "id": 123458,
    "customer": 789,
    "email": "vader@the-death-star.com",
    "products": [{"id":456,"quantity":1,"price":200.00}, {"id":789,"quantity":2,"price":120.00}],
    "time": 1389871120
  }

  {
    "id": 123456,
    "customer": 456,
    "email": "obi.wan@kenobi.me",
    "products": [{"id":456,"quantity":1,"price":200.00}, {"id":789,"quantity":2,"price":120.00},{"id":123,"quantity":2,"price":60.00}],
    "time": 1389870977
  }...]
}


After creating this feed, do the following:

  1. Go to Data at my.clerk.io

  2. Copy the URL from your existing feed and save it somewhere. You need to copy it back later.

  3. Insert the URL of your new sales feed and click Update Settings

  4. Click Start New Data Sync and wait for the import to finish. Your products and categories will stay, but all the new orders will be added to the Store.

  5. Put back the URL of your existing feed and click Update Settings again

You have now updated Clerk.io's algorithm with your sales.