Using a comma-separated values (CSV) file is useful when you first ingest or make changes to your products or inventory.
In this guide:
- Download the product CSV
- Format your products list
- Uploading your file
Step 1: Download the product CSV
You can download a CSV file to view the PartsPal template. Select the "Import products" button, make sure you're in the "Products" tab, and then click "Download template".
You will need either Google Sheets or Excel to edit and manage your inventory.
Step 2: Format your products list
A .csv file will begin downloading.
- The first line of the CSV download file is the column headers. You will need to retain this line.
- The template file contains some explanations and examples of how to use the CSV file. You should delete line 2-3 before uploading your file.
The following lines must contain data for your product using the same columns.
-
SKU
SKU (Stock Keeping Unit) is your internal number unique to your store. PartsPal uses the SKU as the "source of truth" for your products. This means, we create a product based on the SKU number, and make any updates to that product based on it.
-
PartNumber & Brand
The PartNumber and Brand columns are required to match your product with a catalog part from GAPC (Partly Catalog), hence add or manage part information.
-
Images
The images should be a URL containing your image, for example: https://i.ibb.co/XxCvn9C/NGK.jpg
If you want to add more than one image, separate the image with a semicolon ";' e.g https://i.ibb.co/XxCvn9C/NGK.jpg;https://i.ibb.co/XxCvn9C/NGK.jpg
If you have a folder with images, instead of the images already hosted on an image host, get in touch with Partly Support team for help hosting your images.
-
RetailPrice
The RetailPrice column is for the price at that your customers will purchase your products.
- Don't include a currency, only the number.
- Check that your CSV does not have a string of decimal numbers. e.g 22.94452
Step 3: Uploading your file
Once you have prepared your file, ensure that you export it as a '.csv' file. Upload it through the file upload manager.