Navigate to the products page.
On the Top Right side, you will see a small icon “Import” click on that, then select Products.
Download the import template from the popup
Open the excel file there will be 3 pages.
- Product information
- Main & Sub
- Kits
Product Information
To Create a new SKU or to update an existing You just enter the SKU in Column B, see sample below.
The system will know if it is a new or existing SKU,
Only the SKU is required to continue all other columns are beneficial but not required.
Main & Sub
In column A you enter your main SKU
Column B enter your sub SKU. If you have multiple subs from the same main sku you need to enter the main sku as many times as subs you have.
Column C you enter the quantity of the main as received from supplier.
Colum D you enter the quantity of the sub, In example you purchase it as a 1 piece and sell it as 2 piece or vice versa.
See filled example below,
Kits
Column A you enter the KIT sku
Column B you enter the main SKU in reference to the original item.
When excel file is filled and complete, just upload the information and it will be imported.
For your understanding of the main, sub and kit concept, click here.