Export Ecommerce Products and Product Groups to CSV
This process offers a csv file that contains all product data for our Private Catalog products. We can then use the export to make edits and then import back into the E-Commerce Configuration.
Browse to File Center from the main navigation bar.
Step 1 - Export Products
On the left-hand menu under Catalog Export, click "Private Catalog: Export Products”. Then click “Submit”.
This will initiate a job that will provide you with your product data. Allow up to 30 minutes for this to complete.
Step 2 - Retrieve Export
Check back in File Center where you will see the job that you had just run. Jobs will move between statuses of Pending > Processing > Complete. Once you see your job has completed just click into the blue hyperlink and it will download the export file to your computer.
Step 3 - Make Changes
The csv file that was exported will contain sixteen (16) columns:
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. Examples of Brand/Manufacturer: Sea-Doo, AFX, Stillen, Kubota, Seizmik, Yamaha.
ProductGroup.name (required)
Examples of Product Group Name: Force Gloves, Outpost Jacket, GX-J Boots. 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 Product Group 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 can be multiple MPNs in a Product Group.
In the example below the Manufacturer is HJC, Product Group is CL-17 Punisher 2 Helmet. MPN: 862-757 is a Product
It is possible 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. The platform has other features that will allow you to adjust the sale price of the product. MSRP is most commonly referenced for aftermarket products.
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 inside or outside of the E-Commerce platform.
HTTP or HTTPS will work.
Multiple images is supported. Simply place a semicolon in between each image URL. No spaces required. Just ";"
Product.height (optional)
Inches. No Decimals
Product.width (optional)
Inches. No Decimals
Product.depth (optional)
Inches. No Decimals
Product.weight (optional)
Pounds. Decimals are OK.
Product.is_used
Denotes a used product. This field is typically only used by salvage shops/yards. Enter a 1 in the column if the product is used.
Product.condition_notes
This is used for used products/parts. Scratched, Oxidized, etc. Leave blank if you are working with new products.
DistributorPart.distributor_sku
For Private Catalog the distributor sku is the same as the mpn.
Step 4 - Import Products
We cover this in a different article; Private Catalog: Import Products
