Stock Management
Stock Management
Take control of your product stock and inventory using the Stock Management System in OnPrintShop.
With real-time inventory tracking, you can inform your customers about the remaining product stock and restrict them from ordering the out-of-stock products.
This will help you meet the inventory deadline request, avoid rush order fees from vendors by promising customer delivery dates that cannot be met at current stock quantities.
In the OnPrintShop system, we offer two types of Stock Management; Only Size and Size with Product Options.
Set any product’s (standard, pre-defined, etc.) stock from – Admin >> Product >> ‘Action Menu’ >> Edit
Under Configuration setting, you’ll find Enable Stock Management setting.
- None – The product stock will not be maintained.
- Only Size – Maintain the product stock with respect to size.
- Example for T-shirt product manage stock according to their sizes.
- Size with Product Options – Maintain the product stock with the combination of Size and Additional Options
Only Size
Consider the below scenario, here the Sports bag product has two Sizes – Standard and Backpack.
Once, the Stock Management is enabled, you’ll find a new tab – Stock.
From this screen, you can manage, add, debit, view history, and import stock for a particular product.
To add/credit a product stock, click on button.
In the pop-up, enter stock to be added/credited, enter comments and select Add/Credit+ from the dropdown.
This section gives a provision to the Admin such that they can add or debit stock manually. You can add the inventory from this section.
The stock is automatically debited when an order is placed.
Stock History
You can view Product Size Wise stock history or Product Wise stock history.
Product Size wise history – Here, you can see the stock summary of Sports Bag product of Standard Size.
Similarly, if you click on the History button , you can check the product’s stock history, this will include all the product sizes.
- Total Credited Stock: Total stock credited for this product.
- In this case, it is 5000 for Backpack Sports Bag and 1000 for Standard Sports Bag.
- So Total Credited Stock is 5000 + 1000 = 6000.
- Total Debited Stock: Total stock debited by the customer i.e. the quantity of the order placed. It shows data of both online and offline orders.
- In this case, there are 6 orders placed for both Standard and Backpack sports bags. So it is 1200.
- Total Remaining Stock: This is the result of credited stock minus the debited stock.
- In this case it is 6000 – 1200 = 4800
-
Export Stock History: This creates an excel file of all the stock debited and credit action.
- This will help you analyze stocks, orders and manage stocks.
Size with Additional Options
Once the setting is – Size with Additional Options then, when you land on the stock page you can select options to create a combination. Using this combination, you can manage stock.
Add Default Stock – The stock entered here will be added for all the option combinations available for the product in the system.
Select the options to create stock.
Once the combination is created and default stock is added the Manage Stock screen will look something like this.
- Here, you can anytime edit the existing combination and create a new one.
- Delete the current combination and start afresh.
- View the default stock added for the combination.
Rest all the things like history and viewing stock remain the same as the Only Size option.
Stock Setting
You can add a stock setting for each product for which you are managing stock.
Click on the Stock Setting and perform the following settings –
- Notify me when the stock reaches at
- This will trigger an email - ADMIN_STOCK_NOTIFICATION when the stock reaches the quantity defined in the textbox.
- See email content from – Admin >> Content Management >> Email/SMS Notification
- Allow order if the product is out of stock?
- If enabled, then the customer will be able to place an order despite the product being out of stock.
- If kept disabled, then the customer can see that the product is out of stock but they cannot proceed to place an order.
Import Stock
Importing Stock is similar to any other Import Function.
Pre-requisites are –
- Stock management should be enabled for the product.
- If stock management is Size with Additional Option based then make sure you have made the product combination as explained above.
Step – 1 Download the file
To download the file, select stock type – All, Only Size or Size with Product Options.
- Depending on the stock type selected, you’ll get the product list.
- Select the product(s) to import stock.
- Finally, download the file.
Step – 2 Fill up data
Once you download the file, the following fields will be pre-filled in it –
Product ID – Product id of the product as saved in the system (database).
Product Size ID – Product size id of the product as saved in the system (database).
Product Additional Option ID – Product Additional Option id of the product as saved in the system (database). Applicable only if the Stock Management Type is Size with Product Options.
Option Attribute ID – Product Additional Option Attribute ID is saved in the system (database). Applicable only if the Stock Management Type is Size with Product Options.
Product Title – Title of the product as defined in the system.
Size Title – Size Title as defined in the Designer Options.
Additional Option Title – Additional option titles as defined in the system. Applicable only if the Stock Management Type is Size with Product Options.
Additional Option Attribute Names – Product Additional Option Attribute Names as defined in the system (database). Applicable only if the Stock Management Type is Size with Product Options.
Product Stock – Enter the product’s stock to update in the system.
Type – Define whether the entered stock is to be Credited or Debited.
- Use D for the debited stock.
- Use C for the credited stock.
Comments – Enter comments if any for every stock credit and debit.
Step – 3 Upload File
After filling in the stock details, upload the excel file.
The system will show the imported data summary.
The incorrect records will be skipped and you’ll be able to check its summary. Also, you’ll get the summary of correct records.
To import the data, click on Import.
You’ll see a summary of all imported data. One can anytime click on Undo to revert the action.
Front End
If you maintain stock of any product, then customers will get the following type of Stock Alert at the front end.
If you maintain stock of any product, and the product is out of stock then the customer will get the following type of Out of Stock Alert at the front end.
Admin – Offline Order
When Admin places an order from Admin Panel, they’ll also get stock alert as shown below.