Getting Your Catalog Data into PSS

There are two different ways for PSS to ingest your Private Catalog Data.  

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"

*If you do not see this option please email support@powersportsupport.com and request that it be activated.

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
You want to group similar products with different attributes together so that they can display on a marketplace with dropdowns or attribute selectors.  Don't let size, color, or option leak into your ProductGroup.name.  Utilize the size, color, option columns the way they are meant to be used.
Product is a unique MPN.  There is only one MPN per product.  A  Product Group is all the different variations of a single product.  There are multiple MPNs in a Product Group.

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!

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

Pounds.  Decimals are OK. No abbreviations or text (lbs, etc)

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)

Step 3 - Add Price & Inventory

Quantity

The number of items that you have in stock at the time of product creation.

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 4 - 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)
You want to group similar products with different attributes together so that they can display on a marketplace with dropdowns or attribute selectors.  Don't let size, color, or option leak into your ProductGroup.name.  Utilize the size, color, option columns the way they are meant to be used.
A Product is a unique MPN.  There is only one MPN per product.  A Product Group is all the different variations of a single product.  There are multiple MPNs in a Product Group.

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 which 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

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)

Pounds.  Decimals OK.

Step 3 - Upload Your Data

When you click "Private Catalog: Import Products" you will see "Choose File" next to File Upload.  Click this button to locate the file on your computer.  Double click your file and it will be ready to go in PSS.
Enter your email address if you want to be notified when the job is complete.  (optional).
Click Submit

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.

Still need help? Contact Us Contact Us