Getting Your Catalog Data into PSS
There are two different ways for PSS to ingest your Private Catalog Data.
- Add Product with the User Interface
- Import Product with CSV Files
If you are new to this feature and have not read the Private Catalog Overview article please stop here and visit it. The content in the article provides a solid leap off point for Private Cataloging. If you have already reviewed it then let's get your products into PSS and online NOW!
Add Product with the User Interface
PSS Home Page > Catalog > Private > Click Blue Button "New"
Click the "New" button
Step 1 - Create a New Product
To begin with, you will create the product's foundation with two core attributes; Brand/Manufacturer and Product Group Name.
Brand/Manufacturer
The name of the brand manufacturer. You will want to make sure that you watch your spelling to make sure that you don't accidentally get the same brand in twice.
Product Group Name
Step 2 - Add Images and Product Details
Add/Upload a New Image
You can drag images directly from your computer files or you can select images directly from your PSS Media Center. If you are not familiar with Media Center we highly recommend that you take a moment to review its capabilities. Product Image management/hosting has never been easier!
*Multiple images is supported. Upload as many as you wish.
Manufacturer Part Number
The MPN from the Manufacturer or Original Brand.
Size
Large, Medium, Small; 8, 9, 10, 11; 80.00mm, 90.00mm, 100.00mm, etc
Keep your naming conventions consistent throughout all of your apparel data. You can also do LG, M, S if you want, just keep it the same for all product lines. That way when people are shopping around your site or a marketplace everything looks and feels familiar and organized.
Color
Same as above. Red, Yellow, Green will work great. RD, YLW, GRN will also work if you want. Just keep it consistent with ALL of your catalog data.
Option
Use this field if there is a key option on a product line that you feel would be nice to have a shopper toggle on. Or if there are is a product that has like a color line with chrome or black accents. Here are some things we see people use for a Product Option:
Titanium, Steel, Aluminum, Carbon Fiber, Stainless Steel
Knurled, Deep Cut, Slot Track, Dimpled
Chrome Accent, Gloss Black Accent, Carbon Fiber Accent
Standard, Short, Long
MSRP
The MSRP for the product. There are additional fields for "Sale Price" which are covered below.
Used/New
Check the box if it is a used product. This designation will follow the product to eBay so that it is properly marked on the marketplace.
UPC/GTIN
Some marketplaces utilize a Universal Product Code or Global Tracking Item Number. If input, PSS will push to the marketplaces for you.
Weight
Ounces only. No Decimals. No abbreviations or text (lbs, Oz, etc). i.e. a value of 17 is 1lb 1oz
Height, Width, Depth
Inches. No Decimals. No abbreviations or text (in., ", etc). Just raw numbers.
Condition Notes
Mainly used for Used Parts Sellers. (Heavily worn, oxidized, deep scratch, like new, etc)
Example
Step 3 - Add Another Variation or Create Another Product Group
After you create the initial Product Group you will have an option to add another variation to the group, or closeout and create another product.
Step 4 - Add Price & Inventory
After you initially create the product you can add inventory, pricing, and fitment by clicking into an MPN in your Private Catalog
Quantity
QuantityThe number of items that you have in stock at the time of product creation. If a product sells Qty. 1 on eBay then the Shelf Quantity will be decremented by 1.
Lead Time
How many days you would need to get tracking to the customer. If it is in your shop this would typically be a value of 1 (1 day).
Sale Price
The price that you want to sell the product for.
Step 5 - Add Vehicle Fitment
You must add each Year, Make, Model possibility. There is no way to just import a range. To get the YMM search bar to function correctly every unique vehicle must be represented.
Import Product with CSV Files
PSS Home Page > File Center
Near the bottom of the left-hand nav under " Catalog Import", click "Private Catalog: Import Products"
Step 1 - Download Template
Download the Compatible File Template which is in the blue hyperlink. Open the File Template from your computer.
For this template and any others in PSS, make sure that you review the developer notes so that you can ensure that your file meets PSS specifications.
Step 2 - Populate Template With Your Data
This template has seventeen (17) columns, some of which are optional. Below we offer an explanation of what each column header represents.
Manufacturer.name (required)
The name of the brand manufacturer. You will want to make sure that you watch your spelling to make sure that you don't accidentally get the same brand in twice.
ProductGroup.name (required)
In this example below the Product Group is CL-17 Punisher 2 Helmet. MPN: 862-757 is a Product
It is possible, however rare, that a Product Group is represented by only one Product.
ProductGroup.description (optional)
This is where you put the general description of the product. Bullet points, etc.
HTML is recommended but not required. Most products within a Product Group will have the same description.
Product.manufacturer_part_number (required)
The MPN from the Manufacturer or Original Brand.
Product.msrp (required)
The MSRP for the product. PSS has other features that will allow you to adjust the sale price of the product.
Product.size (optional)
Large, Medium, Small; 8, 9, 10, 11; 80.00mm, 90.00mm, 100.00mm, etc
Keep your naming conventions consistent throughout all of your apparel data. You can also do LG, M, S if you want, just keep it the same for all product lines. That way when people are shopping around your site or a marketplace everything looks and feels familiar and organized.
Product.color (optional)
Same as above. Red, Yellow, Green will work great. RD, YLW, GRN will also work if you want. Just keep it consistent with ALL of your catalog data.
Product.option (optional)
Use this field if there is a key option on a product line that you feel would be nice to have a shopper toggle on. Or if there are is a product that has like a color line with chrome or black accents. Here are some things we see people use for a Product Option:
Titanium, Steel, Aluminum
Carbon Fiber, Stainless Steel
Knurled, Deep Cut, Slot Track, Dimpled
Chrome Accent, Gloss Black Accent, Carbon Fiber Accent
Standard, Short, Long
Product.image_url (optional)
For images hosted outside of PSS
HTTP or HTTPS will work. If you plan to list on eBay you will want to make sure the image URLs are HTTPS
*Multiple images is supported. Simply place a semicolon in between each image URL. No spaces required. Just ";"
Product.image_file_name (optional)
For use with PSS Media Center. If you go into Media Center and upload an image, you simply need to copy/paste the image file name into this column.
Product.height (optional)
Inches. No Decimals
Product.width (optional)
Inches. No Decimals
Product.depth (optional)
Inches. No Decimals
Product.weight (optional)
Ounces only. No Decimals. No abbreviations or text (lbs, Oz, etc). i.e. a value of 17 is 1lb 1oz
Step 3 - Upload Your Data
Step 4 - Monitor Job Processing
You will want to monitor the Import that you just ran in File Center. The job will be in a Pending or Processing status until PSS has completed it. These jobs typically take 30-60 minutes depending on the size of the CSV file.
Once finished you will see the job Completed or Complete w/ Warnings. Click on the job and you will have access to a Processing Report. Open the report and the success or failure of each line item will be reported.