Product SKU, GTIN & Inventory

While DecoNetwork handles SKU codes and GTIN automatically you may wish to modify these to suit your business needs. Additionally, inventory control is set for the product on this screen. Inventory control will generate purchase orders for stock in a low-level state as determined by your settings. Low stock level warnings are also issued as emails to team members in the Admin and Purchasing roles.

Prerequisites

• You must have administrator access to use this feature
• Purchase Order generation requires the Purchase Order App to be enabled

To manage SKU, GTIN, and Inventory for a product:

1. Log into your DecoNetwork Website.
2. Browse to Admin > Products.

   

   

3. Select a product to configure by either:
   • Clicking on the product code.
   • Clicking on the product name.
   • Clicking on the Manage button beside the product you want to configure, then selecting Edit Product.
     

   The product properties will be shown in the main work area, with a menu at the left to select property categories. General will be selected by default.

4. Select SKU, GTIN & Inventory from the product properties menu.
   

   The main work area contains the configuration options for SKU, GTIN, and inventory.

   

   Click the image to enlarge.

   

   Click the image to enlarge.

5. Configure the settings as required.

   Inventory Settings

   You can customize the inventory settings for this product to override the global out-of-stock behavior, which is set in Admin > Products > Inventory Settings.

   

   • Use Default Inventory Settings: Choose this option to apply the standard out-of-stock behavior that has been configured globally in Admin > Products > Inventory Settings.
   • Specify Custom Inventory Settings: Choose this option to override the global out-of-stock inventory behavior. Select an option from the Out of stock behavior dropdown list:
     • Allow adding to cart: Select this option if you want to allow customers to add out-of-stock products to their cart.
     • Do not allow adding to cart (check on-hand inventory): Select this option if you want to stop customers from adding out-of-stock products to their cart.
       • This setting only applies to products with on-hand inventory tracking enabled. For instructions on how to enable inventory tracking, refer to the article, How to enable on-hand inventory for a product.
     • Do not allow adding to cart (check supplier inventory): Select this option if you want to prevent customers from adding products to their cart that are out of stock in supplier inventory.
     • Do not allow adding to cart (check both on-hand and supplier inventory): Select this option if you want to prevent customers from adding products to the cart that are out of stock in both on-hand inventory and supplier inventory.
       • Catalog products with on-hand inventory tracking enabled will check both on-hand and supplier levels. The on-hand inventory is checked first and if that is out of stock the system will then check supplier inventory level.
       • Supplier inventory check applies to DecoNetwork catalog products from suppliers with live ordering enabled.
       • Custom products with inventory tracking enabled will only check on-hand inventory levels.
       • The system will hide products from blank product and decorated product lists if they are completely out of stock (across all SKUs) at both the local on hand inventory level and the supplier inventory level.
       • Supplier inventory amounts can be viewed in the blank product SKU, GTIN & Inventory page and also in the Inventory On Hand page in Business Hub.
       • Supplier out of stock threshold (consider out of stock if available quantity is below the entered quantity): This field allows you to specify the minimum supplier inventory level at which you want to allow customers to add products to cart. If the supplier inventory level is equal to or less than the specified amount, customers will not be able to add products to cart when using supplier inventory settings.

   SKU Item Information

   

   The Manage size/color combinations feature allows you to configure and manage different size and color options for your products. Clicking on the link will bring up the Manage size/color combinations popup.

   

   Choose an option from the dropdown box:

   • Use supplier color/size combinations: Colors and sizes are available based on vendor stock.
   • Don't limit color/sizes: All colors will be available for every size.
   • Limit color/sizes: Enables the checkboxes so that you can choose specific size and color combinations.

   SKU Table

   Ticking the Enable inventory on hand for this product checkbox will reveal the inventory columns for the SKU table.

   

   Click the image to enlarge.

   • Color the color of the product.
   • Size the size of the product.
   • Sub Size the size of the product.
   • SKU Code a series of identifying numbers and letters assigned to a product that is used to track your inventory.
   • GTIN a globally unique series of numbers and letters used to identify the product for trade.
   • [Supplier Name] Inventory the amount of inventory the supplier has in stock for the SKU.

     The supplier inventory amount will only be available if you have configured live ordering for the supplier.

     Click here for instructions on how to enable live ordering.

   • Stock Item? enabling this turns on inventory tracking for this item. The topmost checkbox will select all items on the page when ticked.
   • Location lets you enter/edit the coordinate number of the storage bin where the item is located, giving you more control in managing your inventory.

     The location number will appear on the Production Worksheet, Purchase Order Stock Sheet, Order Inventory Pull Sheet, Packing Slips, and in the popup that appears when clicking on the Ordered or Received column while viewing the Production tab of an Order in Business Hub.

   • Inventory On Hand lets you update the inventory level recorded to the actual amount you presently have in stock if there is any discrepancy.

     After you have changed the inventory level, an icon will be displayed beside the field.

     

     Clicking on the icon will open the Inventory Change Reason popup, allowing you to enter a reason why the inventory level was manually changed.

     
   • New Inventory Level lets you make a correction to the Inventory On Hand level recorded if there is any discrepancy with the actual inventory level you have in stock.
   • Low Stock Warning lets you modify the inventory level at which a warning email will be sent to relevant team members informing them of the situation.
   • Reorder To Level lets you modify the amount of product to which a purchase order will aim to restock your inventory level.
   • Inventory On Order shows the present amount of the product that has already been ordered, but not yet received.
     • For Stock: shows the number of inventory items on order for stock-keeping.
     • For Orders: shows the number of inventory items on backorder to fulfill sales orders.
   • To Order shows the number of items of a SKU required to be ordered in order to fulfill sales orders.
   • Log opens a log window detailing events relating to the product in terms of inventory level.
     

     SKU

     Displays the SKU information of the product you are viewing the log of.

     Inventory Event Log

     Lists a log of events affecting the inventory level of the product. Events include:

     • Restocked from purchase order: Restock of inventory from purchase order.
     • Restocked from product import: Restock of inventory from product import.
     • Manually changed: Restock of inventory from manual entry.

       If a reason was entered when the inventory level was changed, it will be displayed after the event name., e.g. Manually changed: Miscount.

     • Allocated to Order: Depletion of inventory due to allocating products to an order.
     • Unallocated from Order: Restock of inventory from a canceled order.

     Current Purchase Orders

     Lists the current purchase orders that are awaiting stock to replenish the product inventory to the required level.

   Closing Out

   The Closing Out option lets you choose whether to allow product items to be sold below recorded inventory levels.

   • When the Closing Out checkbox is ticked, the product will only be allowed to be sold to zero inventory. This means that customers will not be able to place orders for any SKUs that do not have inventory. This is useful if you have products on hand that are being discontinued and you want to prevent customers from ordering products that are no longer available after the last of your inventory has been sold.

     Any SKU that does not have any recorded inventory will not be available for sale in the storefront. When a color is not available in the selected size, this will be indicated by stripes through the color selection block.

     Existing orders that contain products marked for closing out will still raise a purchase order if a purchase order has not yet been raised for the products.

   • When the checkbox is unticked, product items will be allowed to be sold below zero. This allows you to keep minimum stock on hand but still be able to sell the product when you have run out of stock.
6. Click Save or Save and Continue when done.