Import Bulk Products
Instead of uploading a single product at a time, OnPrintShop system allows you to mass upload products using an excel sheet. This will reduce down your labor required in uploading one product at a time.
Mass upload product details, pricing, and additional options. Simply follow the below steps to successfully import products into your store.
Importing the products in the store in bulk is a 5-step easy process.
Step – 1 Download Sample File
Download the sample file and fill in the details in the sequence of the tab. Keep in mind the following points while filling in the details in the excel sheet.
You also get the provision to select a product and download the sample data with real-time product information for reference. You can download sample data of an existing product and easily fill the rest of the sheet, thus saving a hefty amount of time.
Select Product - This dropdown allows you to choose a product to download sample data for reference. At a time you can choose one product and download the sample file.
- Do not delete or interchange any column.
- Do not change the title of the column.
- Columns with titles in ‘yellow’ are mandatory to fill.
- For any help in the column titles, look at Step – 2 for guidance.
- Before filling in data in the Excel file make sure that you have, the same measurement unit set in your Admin Panel. Check the unit from Admin >> Store Configuration >> Settings >> Search with “Size” >> Select from the dropdown list for 'Measurement Unit for Product Size'
- If there are multiple price options for a product then drag the product name until you get all the options in the corresponding row cells. For example, if your business card product has 5 different size options then drag the business card into the next 4 more cells and add the remaining option.
Step – 2 Fill Up Data & Help
Here, each column of the Excel sheet is explained such that it becomes easy for the Admin to fill in the data
Step – 3 Upload File
This section only accepts files in .xls format. Make sure the data is filled correctly before you upload the file.
Select the product type from the drop-down and click on the Upload File.
Step – 4 Map Database Field
The system maps the data of the excel file. You can also check all the details entered into the excel sheet.
Step – 5 Imported Data Summary
Once the file is uploaded, the system will display the summary of the data similar to as below:
If all the data entered is correct, click on the Import button to upload all the product details and other information.