Inventory

Every combination of product, variation and size has a unique inventory level in Stitchex. As you ship products to your customers and receive products from your manufacturers, inventory levels are updated accordingly and you should always have an accurate measure of your current inventory available to you via the reporting interface.

Stitchex also tracks the production quantities required to cover your sales, as well as quantities awaiting delivery from your manufacturers. These quantities are available as reports via the Inventory tab.

Updating inventory

The normal workflow for increasing your inventory is to create, confirm and "receive" a production order. In some cases you'll want to set or adjust inventory levels manually. You can do this in one of the following ways:

  • Set inventory levels directly from a product details page.
  • Creating a manual inventory adjustment.
  • Exporting/importing a spreadsheet of inventory levels.

Setting inventory levels directly

To set the "in stock" inventory level directly for a product perform the following steps:

  1. Navigate to the product details page.
  2. Click the SKUs button the top of the page.
  3. For each SKU, enter a stock count into the fields below "In Stock".
  4. Click the "Update Product" button.

Creating a manual inventory adjustment

If you have a small number of adjustments to make, or you know the exact additions or subtractions you wish to make, then creating a "manual adjustment" record is the quickest way to update inventory levels. To create a manual adjustment:

  1. Navigate to Inventory page and select "Update inventory".
  2. Click the drop-down button and select "New manual adjustment".
  3. A new inventory adjustment record will be created and the 'Select Products' dialog will open automatically. Select some products to add to the adjustment. You can always add more products later. Click the "Add Products" button.
  4. Enter the inventory adjustments quantities. Enter positive values to increase the inventory level, negative values to reduce an inventory level.
  5. Click the button to optionally add a comment explaining the reason for the adjustment.
  6. When you are ready to apply your adjustments, click the "Apply →" button. You will have the change to undo your change if a mistake was made.

All stock adjustments are listed on the left side of the update inventory page:

You'll notice that draft/unapplied adjustments are listed at top, above the grey arrow. As you apply the adjustments, they are transferred down to the list of applied adjustments. The green quantity values indicate quantities added to inventory, and the red values indicate quantities deducted.

Navigate to a particular adjustment by clicking it within the adjustment list.

The "Filter by product" input box can be used to search for adjustments that contain a particular product. You can enter a product name or product identifier in this box. Click the button to perform the search.

Importing inventory levels

In a typical stock-take scenario (where you wish to record and enter total quantities counted), it's likely that you'll want to use the import spreadsheet method of updating inventory levels.

To get started, you'll most likely want to export a spreadsheet (containing current inventory quantities) that you will edit, save, and import back into Stitchex. The spreadsheet will be in the correct format and contain all current product SKUs. To download such a spreadsheet take the following steps:

  1. Navigate to Inventory page and select "Update inventory".
  2. Click the drop-down button and select "Import spreadsheet...".
  3. The "Upload inventory spreadsheet" dialog will open.
  4. Click the "Download current stock levels CSV" link.

Your spreadsheet file will now download to your computer. Edit the file with the spreadsheet of your choice. It will look something like this:

Count your stock and update the values below the "in stock" column with new total inventory counts. Save or export your spreadsheet in tab delimited CSV format.

To upload the amended spreadsheet, click the "Choose File" button, select the file on your computer, and click the "Upload CSV" button.

Stitchex will compare the quantities in your spreadsheet to the current stock levels in the system. A unapplied "stock import" record will be saved and displayed. It will look something like the following, with additions and subtractions shown in green and red:

You can adjust the quantities if necessary, then apply the changes to your account by clicking the "Apply →" button.

Next steps

Did this answer your question?