How to upload your Product File (CSV)
PartsPal requires you to upload a separate Stock List file to your product file. This system is set up to allow you to make updates to the stock, locations & price easily in the future without affecting your product list.
Download the PartsPal Stock Template
Firstly, download the template for the CSV using the link below. You can then open your CSV File in Google Sheets (free) or Excel for a larger inventory.
Download CSV Templates
How it works
The first line of the CSV file is the column headers. The following lines must contain data for your product using the same columns in the same order.
SKU (Stock Keeping Unit) is your internal stock number unique to your store. We use 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.
The SKU will be very useful moving forward. If you want to make any changes to your inventory such as adding an image or adjust stock levels, you will upload a file containing the SKU and the Column header of the attribute you want.
Quantity The number of items you have in stock of this product. ****💡
AddressID PartsPal generates a unique addressID for your address. To find this address ID, head to your Settings > Shipping > Locations and click on the address.
The external ID is assigned by your sales channel (eBay/Shopify). Make sure you are using the AddressID, not the external
Checklist before uploading
Before uploading your file, make sure to check for these below.