Listing a Product That Already Exists in Newegg's Catalog Using a Spreadsheet

If the product you want to sell already exists in Newegg's catalog, you can easily add yourself to the existing listing by providing Solid Commerce with a UPC, ISBN, or Newegg Item #.

 

What we'll cover:

  1. Steps to Take Before Listing to Newegg
  2. Three Product Identifiers You Can Use When Listing
  3. Required Fields
  4. Optional Fields
  5. Uploading Your Spreadsheet
  6. Downloadable Excel Template for Listing Products to Newegg's Catalog
  7. Related Articles

Steps to Take Before Listing to Newegg

You need to perform the following steps before you can list to Newegg. If you have already completed them, you're ready to download the Excel template and use the table of fields below to populate it.

1) Connect to Newegg (see Connecting to the Newegg Marketplace) and create a Newegg Market List (see Creating a Market List).

2) Create your product in Solid Commerce and add it to inventory. See the Related Articles section for more information.

Three Product Identifiers You Can Use When Listing

To add yourself to listings that already exist in Newegg's catalog, provide one of these product identifiers.

Product Identifier Type Description and Listing Information
newegg item number

Newegg assigns a unique product code to each listing.

When listing products, we give the Newegg Item # priority over the UPC and ISBN. For example, if you provide both the Newegg Item #, and the UPC, we will ignore the UPC and send the Newegg Item # to Newegg.

Most people don't have the Newegg Item #s for their products, so they list via the UPC or ISBN instead.

If you are going to import active listings from Newegg, you will want to use the Newegg Item # during the import. See Importing Active Listings From the Newegg Marketplace.

upc or isbn

If you don't have the Newegg Item # for your products, you can provide Solid Commerce with the Universal Product Code (UPC).

If you are selling books, you provide us with the International Standard Book Number (ISBN) instead of the UPC.

Required Fields

Required Fields
Field Description and Valid Values
results Leave this field blank. It will automatically populate if you upload the file using the Solid Commerce Excel Add-In Tool.
product custom sku The SKU of your product.
warehouse id The Warehouse ID of your product. The Warehouse ID is usually the same as the Product Custom SKU.
upc

Provide a upc if you plan to list to Newegg's catalog via UPC.

If you are using a different product identifier, you do not need to provide the UPC.

isbn

Provide an isbn if you plan to list to Newegg's catalog via ISBN.

If you are using a different product identifier, you do not need to provide the ISBN.

newegg item number

Provide a newegg item number if you plan to list to Newegg's catalog via Newegg Item #.

If you are using a different product identifier, you do not need to provide the Newegg Item #.

manufacturer

manufacturer is a required field if you are listing via a UPC or ISBN.

It is an optional field if you are listing using the Newegg Item #.

newegg price exp

This field controls the price of your item on Newegg.

You can enter a number without a currency symbol, or you can enter simple formulas with the word cost, such as cost*1.5 or cost+7. More complex formulas like cost*1.2+5 or ((cost*1.2)+5) work as well.

market auto rule We created a default rule to keep things simple. Enter: Newegg Default in this column.
list name The name of your Newegg Market List in Solid Commerce.
po sources

The name of the Warehouse(s) Solid Commerce should use as the inventory source for your listings.

newegg qty exp

Enter lq in this field if you want to make your entire inventory available on Newegg. You can also enter formulas. See Using the Listing Quantity Expression to Control the Quantities on Your Listings.

run newegg

Enter Yes to turn the automation on. We will automatically push your product data to Newegg for listing. If you enter No, your product will not list until you turn the automation on.

Optional Fields

Optional Fields
Description and Valid Values
newegg shipping

If you do not include the newegg shipping column during your upload, we will automatically set the shipping setting to Default. Your listings will be using the shipping settings you established on Newegg to control your listing.

If you want to offer free shipping on some, or all, of your listings. Include the newegg shipping column in your upload file and populate it with a value of Free.

Valid Values:
Default or Free

product name
The name of your product. This field is not required, but can be handy as a reference.

Uploading Your Spreadsheet

To upload your file using our Excel Add-In Tool, click the Upload Data button and check only the Update Marketplace box.

rakuten_integration_excel_marketplace_update.png

 

To upload the file through our web uploader instead, go to the Products menu -> Import Products and Inventory. Select the Import Marketplace and Newegg options.

newegg_integration_listing_web_uploader_settings.png

 

NOTE: Our listing service runs on a cycle. It may take up to 10 minutes for us to submit your items to Newegg.

Downloadable Excel Template for Listing Products to Newegg's Catalog

You can use this template to list products to Newegg. It is also populated with a sample product.

Related Articles

 

Back to top

 

The attachment from the Downloadable Excel Template for Listing Products to Newegg's Catalog section:

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.