Inventory settings
Company-wide inventory preferences β display timezone, product images, restrict reasons, auto-creating catalog SKUs and undoing uploads.
What it's for
The Inventory box holds inventory preferences that apply to every channel:
- which timezone dates and times are shown in,
- where product pictures come from,
- whether a reason is required when you restrict a SKU,
- how new catalog SKUs are created from vendor (source) SKUs,
- and a one-hour "undo" for spreadsheet uploads.
Channel-specific inventory settings (what quantity is sent to Amazon or Walmart, sync schedules, handling time) are under Channels. See Channels and stores.
Where to find it
β Settings β General settings β Inventory. The panel has four tabs: Images, Restrict, New SKUs and Undo uploads.
The screen at a glance
Images tab
Time β Display timezone. Pick Eastern, Central, Mountain, Arizona, Pacific or UTC. Timestamps such as warehouse history are shown in this zone, whatever your computer's own clock says. It saves as soon as you pick.
Images (all channels):
- Pull image from Channel SKU β catalog SKUs take their picture from the single-pack listing on your channel, when one exists.
- Pull image from Catalog β source (vendor) SKUs show the picture of the catalog SKU they are linked to.
Restrict tab
Restricting a SKU sends 0 inventory. Restricting a catalog SKU restricts all of its listings. A restricted vendor (source) SKU is never ordered from.
Three switches decide whether someone must pick a reason before restricting:
- Catalog SKUs β require a reason
- Source SKUs β require a reason
- Channel SKUs β require a reason
Each switch saves the moment you flip it.
New SKUs tab
Auto-create Catalog SKU from Source SKU. For every source SKU that has no catalog SKU yet, OrderPilot can create one. Source SKUs that already have a catalog SKU are skipped.
- Build the catalog SKU from β Vendor SKU, UPC or NDC.
- and add β a short tag (for example
_OP) and whether it goes After or Before the base value. - The Example line shows what a new SKU will look like, for instance
037000919841_OP.
Auto-create from EDI. Turn on Create automatically after each 832 to run the same recipe every time a vendor catalog (832) file is processed. This switch saves on its own.
Undo uploads tab
Lists your spreadsheet uploads from the Imports screens over the last 7 days. Each row shows when it ran, how many rows it changed, and how many listings and catalog SKUs it created. An upload can be undone for 1 hour after it ran. After that the row says "too old (>1h)". Rows already reversed say "undone".
Buttons and actions
| Button | What it does |
|---|---|
| Save images | Saves the two image switches and the timezone. |
| β» Backfill images now | Fills in missing pictures right away using the image switches, then shows how many catalog and source images were set. |
| Save (New SKUs) | Saves the auto-create recipe (base field, tag, before/after). |
| βΆ Create now | Creates catalog SKUs now for every source SKU without one. It reports how many were created, how many were linked to an existing catalog SKU, and how many were skipped because the chosen field was empty. |
| Create automatically after each 832 | Switch. Runs the recipe after every vendor catalog file. |
| β© Undo (Undo uploads) | Asks you to confirm, then reverses everything that upload changed: links, bundles, titles, prices, ASINs, and deletes rows it created. This cannot be re-done. |
How to create catalog SKUs from your vendor items
- Open Settings β General settings β Inventory β New SKUs.
- In Build the catalog SKU from, pick UPC (or Vendor SKU or NDC).
- Type a tag in the and add box, for example
_OP, and choose After or Before. - Check the Example line.
- Click Save.
- Click βΆ Create now. Wait for the result message.
- Optional: turn on Create automatically after each 832 so new vendor items get a catalog SKU without you doing anything.
How to undo a bad upload
- Open Settings β General settings β Inventory β Undo uploads.
- Find the upload by its name and time.
- Click β© Undo and confirm.
- A message tells you how many listings and bundle sets were restored and how many created rows were deleted.
Tips and troubleshooting
- The Undo button is missing. The upload is more than one hour old. Undo is no longer possible; fix the data with a new upload instead.
- "Create now" skipped many items. Those source SKUs have no value in the field you chose (for example no UPC). Try Vendor SKU as the base, or fill in the missing UPCs.
- There are two timezone settings. The one here is saved for the whole company. The one under Site is saved only in your own web browser. See Site settings.