Support › Stock

Sell your store's shelf stock online

Short answer

Connect your POS's inventory export and online customers can buy what's on your shelves, on its own or on top of EJD's stock. Set it up on Stock > Set up store stock.

The app can read an inventory export from your POS (point-of-sale system) and show your shelf stock online. You choose, for your whole store and item by item, where online stock comes from:

Source What customers can buy
EJD only What EJD's warehouses can ship. This is how the app works until you turn store stock on.
My shelf only What's on your shelf, less your hold back.
EJD and my shelf EJD's stock plus your shelf, each after its own rules.

Open Stock and select Set up store stock. Setup takes four steps, and nothing changes in your store until the last one.

Step 1: choose your POS

Pick your POS from the list. If yours isn't there, choose Another system. The app uses your choice to guess which columns hold the item number, UPC and on-hand count. You can change any column in step 3.

Shopify POS needs no file. Your shelf count is already in Shopify, at your store's location. For online customers to buy it, that location must fulfill online orders (Shopify Settings > Locations). The app never writes to that location.

Step 2: how the file gets to the app

  • I upload it. Good for trying it out. Stock is only as fresh as your last upload. If you don't upload a new file for 2 days, you get an alert, and after 3 days shelf stock is turned off online until you upload again.
  • The app pulls it from our SFTP server (recommended). Give the server, username, password and a folder or file. In a folder, the app takes the newest .csv, .txt or .xlsx file. The app only lists and downloads: it never deletes, renames or moves anything.
  • The app fetches it from a link. The link must start with https:// and open without a login.

For SFTP or a link, choose how often to check. Match it to how often your POS exports: every hour is common.

Producing the export

Every POS can export inventory, but menus differ by version, so ask your POS provider to set it up. You need one row per item with:

  • your item number (if your POS uses EJD / Ace item numbers) or the UPC, and
  • the quantity on hand for this store only.
POS What to ask for
Epicor Eagle An inventory report with SKU, UPC and QOH for your store. Ask your Epicor rep to schedule it hourly to an SFTP site.
ECI RockSolid MAX An item or inventory report with item number, UPC and on hand, exported to CSV or Excel. ECI support can schedule it.
Celerant An inventory listing with SKU, UPC and on hand for this store. Celerant support can schedule it to SFTP.
Paladin An inventory export with part number, UPC and quantity on hand.
ECI Spruce An item or inventory report with item number, UPC and on hand.
Epicor BisTrack A stock report for this branch with product code, barcode and free stock.
Rundoo An item or inventory export with SKU, UPC and quantity.
RMH An item export with item lookup code, UPC or alias, and quantity on hand.
Lightspeed An item list or inventory export for this store, as CSV.
Square The item library export. Pick your store's "Current Quantity" column in step 3.
Clover The inventory items export to Excel.
Anything else Any CSV or Excel file with an item number or UPC and an on-hand count.

Export straight from the POS. Opening the file in Excel and saving it can turn UPCs into numbers like 1.23E+11, which can't match.

Step 3: check the columns

Upload one export. The app finds the header row, picks the columns and shows:

  • the first 5 rows, with the column chosen for each job,
  • the match rate, for example "4,812 of 5,030 rows matched an EJD item", and
  • a download of the rows that didn't match.

Rows that don't match are items EJD doesn't carry, or items with a different number in your POS. They're left alone. If few rows match, try matching by UPC instead of item number.

Step 4: where online stock comes from

  1. Choose the default for every item. The screen shows the effect in numbers, for example how many items your shelf puts back in stock that EJD has sold out.
  2. Choose the Shopify location for shelf stock. We recommend letting the app create one, named "Your store (shelf stock)", from your store's address. Use an existing location only if nothing else keeps stock there.
  3. Select Turn on store stock.

Until your first file is read, every item sells from EJD, whatever you chose. Choosing My shelf only before a file arrives can't sell out your store.

Set a Hold back of at least 1 on Stock: it also comes off your shelf count, so the last unit on a shelf isn't sold online and at the counter at the same time.

Setting items one by one

  1. On Stock, under Store stock, paste EJD item numbers into Set items one by one.
  2. Under Stock for these items comes from, choose a source. For example, set bulky items to My shelf only. Use my default removes the item's own setting. Leave as is (the starting choice) keeps each item's source.
  3. Select Save for these items. Both locations update a minute later.

Writing to your store

Store stock follows the same Write stock to my store switch, on Stock, as EJD stock. While it's off, the app reads your files and records what it would show, without changing your store. During the trial, only the sample items are written.

Online orders and your counter

When a customer orders online from your store's location, Shopify holds those units for the order until you fulfill it. They're still on your shelf, so your POS still counts them. The app takes those held units off each file's count, so a pickup that waits a few days is never sold twice.

Ring online orders into your POS promptly. If you ring an online sale in before you mark it fulfilled in Shopify, those units come off twice until you fulfill it: you show less than you have for a short time, never more. If you fulfill in Shopify first, the next file can put the unit back online for a short time until you ring it in. Your hold back covers that gap.

STOCK_STORE_FILE_STALE

No new file has arrived for twice your schedule, for example 2 hours on an hourly schedule. Your store keeps its last shelf counts for now.

If still no file arrives, shelf stock is turned off online until a new file comes: after 3 times your schedule (never sooner than 3 hours) for SFTP or a link, or 3 days after your last upload. Items sold from My shelf only then show sold out, and items sold from EJD and my shelf show EJD's stock only.

  1. Check your POS's scheduled export still runs, and that it saves to the same folder or link.
  2. If you upload by hand, upload a fresh export on Store stock.
  3. The alert clears, and shelf stock comes back online, with the next new file.

For a store under More stores, the same limits apply to that store's own file, on the schedule you gave its link (an upload counts as daily). The alert names the store, and once its counts are too old its row shows Too old, showing 0.

A link that keeps sending the very same file doesn't count as new unless the server gives the file's own time. So if the export behind a link stops running, the file still gets too old and its shelf stock still turns off.

STOCK_STORE_MATCH_DROP

The file matched fewer than half as many items as the last one, for example "1,980 items matched, down from 4,812". That usually means the export was cut short, came from the wrong store, or its columns changed. Nothing was written; your store keeps its last shelf counts.

  1. Open Store stock and download the unmatched rows (for your first store's file).
  2. If the export is wrong, fix it in your POS. The next good file clears the stop.
  3. If the change is real, for example after a big clear-out, select Use file name anyway on the banner and confirm. Items missing from the file lose their shelf stock online.

For a store under More stores, its row shows Stopped and the alert names the store. Select Use anyway on that row to use the file.

STOCK_STORE_FILE_UNREADABLE

The file couldn't be read, or has no on-hand or item number column. Nothing was changed. The alert says which.

  1. If your export's columns were renamed, open Store stock, select Change setup and choose the columns again.
  2. If the file was saved as old Excel (.xls), save it as .xlsx or CSV instead.

For a store under More stores, the app also refuses a file that would count your first store's shelf again: the same file your first store sent, or a Square export read from your first store's quantity column. Upload an export with only that store's quantities.

STOCK_STORE_PULL_FAILED

The app couldn't get the file from your SFTP server or link. The alert gives the server's answer, for example a wrong password, a missing folder, or a link that needs a login. Your store keeps its last shelf counts.

  1. Open Store stock and select Change setup.
  2. Fix the details. The next check uses them.

Turning store stock off

On Store stock, select Turn store stock off and confirm. Your store's location goes back to 0, and so does each store's under More stores. Every item sells from EJD stock again, including items set to My shelf only. Your setup is kept: select Turn store stock back on to use it again, and each store's last counts come back if they aren't too old.

More than one store (Growth)

On Growth, your main store is included and each further store is $49 a month or $420 a year.

  1. Set how many under Extra stores in Plan and billing.
  2. On Store stock, under More stores, name the store, and choose its Shopify location or let the app create one. Each store needs its own location, and it must fulfill online orders for its stock to sell online.
  3. Choose how its stock arrives: upload its POS export, or a link the app fetches. For a link, choose how often its export runs. It uses the same file layout and columns as your first store, so its file needs the same columns.
  4. Add it, then upload its first file.

Each store's shelf count goes to its own location, with the same hold back, per-item sources, trial sample and safety checks as your first store. Changing an item's source or your hold back updates every store's location a minute later. Shopify adds the locations up for what customers can buy. Units Shopify assigns to a store are that store's to fill: they never go to EJD.

Store-only items sell from your first store's shelf only. Their rows in another store's file aren't read.

With Shelf check on, the order screen asks Which store fills these. The units move to that store's location, so its stock online goes down by what it sells.

Remove asks you to confirm, then sets that store's location back to 0 and removes it, with its alerts. The location itself stays in Shopify. If the app isn't writing stock (stock writes are off, or your store isn't live yet), it can't change that location: the confirm says so, and if the location still shows stock from earlier, set it to 0 in Shopify yourself.

Who fills an order

With EJD's location and several store locations, Shopify decides which location each online order goes to. Set this in Shopify under Settings > Shipping and delivery > Order routing. For example, rank EJD's location first for shipped orders, and let pickup orders go to the store the customer chose.

An order Shopify sends entirely to a store location is that store's to fill. It has nothing for EJD, so it doesn't appear under Orders in the app: fill it from that store and fulfill it in Shopify.

If you lower the number of extra stores on your plan, the stores added last show 0 at their locations until your plan covers them again. Nothing is deleted. When it does, their saved counts come back right away, as long as their last file isn't too old.

Technical details

Show the exact rules, for the technically minded

Two locations. EJD's stock and your shelf stock go to different Shopify locations, so neither overwrites the other. Shopify adds up every location that fulfills online orders to get what a customer can buy:

Source EJD's location Your store's location
EJD only EJD's stock 0
My shelf only 0 Shelf less hold back
EJD and my shelf EJD's stock Shelf less hold back

Items sold from EJD only are set to 0 at your store's location, or Shopify would add your shelf to them.

Rules for each part.

  • EJD's part keeps your minimum, hold back and full cases. See Minimum and hold back.
  • Your shelf's part takes your hold back too. The minimum doesn't apply, and it isn't rounded to EJD's case.
  • With EJD and my shelf, the hold back comes off each part, so the item holds back twice your hold back in total.
  • Case listings (Sell by the case) show whole cases from the shelf's eaches: 25 on the shelf with a hold back of 1 is 2 cases of 12.
  • Units Shopify holds for unfulfilled online orders at your location are taken off too: 5 on the shelf, a hold back of 1 and 3 waiting for pickup puts 1 online.

How rows are read.

  • Negative on-hand counts as 0. Recount those items in your POS.
  • Blank on-hand is skipped, not read as 0.
  • The same item twice uses the lowest count, so a shelf is never counted twice.
  • Fractions (rope by the foot) round down.
  • An item missing from a later file reads 0: your POS no longer lists it.
  • Matching by item number also matches your own SKU on any product you linked to an EJD item (see Possible duplicate).

Connections.

  • The server or link must be reachable from the internet. The app won't connect to private, local or reserved addresses (for example 10.x.x.x, 192.168.x.x or a server on your own network).
  • Files over 50 MB are refused. A link can redirect up to 5 times, each to another https:// address.
  • Each time you continue in setup, the app tests the connection: up to 10 tests an hour per store, failed ones included.
  • The SFTP password is stored encrypted and never shown again. A saved password is only sent to the server it was saved for: change the server, port or username and you must enter it again.
  • The server's identity key is saved on first use. If it changes, the app won't log in until you choose Forget the server's key.

When files are too old. The stale alert is raised at 2 times your schedule. Shelf stock turns off at 3 times your schedule (at least 3 hours) for SFTP and links, or 3 days for uploads (uploads count as a daily schedule). While it's off, your store's location is set to 0 and EJD's location isn't changed. The app keeps the old counts but never uses them again, even if you change sources: only a new file brings shelf stock back. An extra store's location stays at 0 until that store's next file.

Related

Still stuck? Open Help and support inside the app to ask about your own store or write to a person.