Importing Active Listings From the Newegg Marketplace

This article will show you how to import the listings from your Newegg account into Solid Commerce so you can manage them through our platform.

Before you import your listings, you need to connect to Newegg (see Connecting to the Newegg Marketplace) and create a Newegg Market List (see Creating a Market List).

 

What we'll cover:

  1. Exporting Your Listings From Newegg
  2. Adding Your Products to Solid Commerce
  3. Importing Your Listings From Newegg
  4. Downloadable Template for Importing Listings
  5. Related Articles

Exporting Your Listings From Newegg

Before you can import your listings into Solid Commerce, you need to export them from Newegg.

1) Log into your Newegg Seller Portal.

2) In the sidebar menu, click on Manage Items. Click on Item List from the submenu that appears.

3) Click the Search button on the upper right-hand site to find all of your items.

4) Click the Export All button at the lower left-hand side.

5) Give the export file a name and select a location on your hard drive to save it.

6) Open the exported file in Excel.

Adding Your Products to Solid Commerce

If the SKUs you're importing from Newegg already exist in your Solid Commerce account, you can skip to the Importing Your Listings From Newegg section below.

If the SKUs you're importing haven't been added to Solid Commerce yet, you will need to add them as part of the import process.

1) Open the Excel template you usually use to add new products to Solid Commerce.

2) Copy the Seller Part #s from your Newegg export. Paste them in the product custom sku and warehouse id columns in your Solid Commerce file.

3) If you provided MSRPs to Newegg, you can copy them from your Newegg export. Paste the MSRPs in the msrp column of your Solid Commerce file.

  • This is an optional field in Solid Commerce. If you have not provided your MSRPs to Newegg, you do not have to populate this field.

4) Copy the Inventory from your Newegg export. Paste the quantities in the qty column of your Solid Commerce file.

5) product name is a required field.

  • The product name can be edited later. Some people simply paste their SKUs in it.

6) Enter the name of your Solid Commerce Warehouse in the warehouse name column.

7) Populate any of the optional fields you would like to add to Solid Commerce, such as the upc, image file, or custom product attributes.

newegg_integration_importing_products_excel_add-in.png

 

8) Upload your file with a Product and Inventory update.

rakuten_integration_excel_product_inventory_upload.png

 

Importing Your Listings From Newegg

1) Download the Newegg.com Importing Listing Template.xlsx file attached to this article and open it in Excel.

2) Copy the data from your Newegg export file and paste it into the Newegg Importing Listings tab of the Solid Commerce template.

Newegg Field Corresponding Solid Commerce Field
Seller Part #s product custom sku
Seller Part #s warehouse id
NE Item # newegg item number
Selling Price newegg price exp
Shipping newegg shipping

 

3) Fill in the following Solid Commerce specific fields:

Solid Commerce Field Field Description
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.
list name Enter 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.
market auto rule We created a default rule to make things easy. Always enter: Newegg Default.

 

4) Set the automation using the run newegg column:

Solid Commerce Field
Field Description
run newegg

Enter No to import your listings with the automation turned off. Enter Yes to import with the automation turned on.

Solid Commerce will automatically sync with your listings when the automation is on.

If you are new to Solid Commerce, we recommend importing your listings with the automation set to No until you are comfortable managing your inventory, prices, and listings through Solid Commerce. With the automation turned off, we will not communicate with your Newegg listings.

For more information about using the automation setting, see An Explanation of the Automation Setting and Marketplace Listing Updates.

 

5) Upload your file with a Marketplace update.

rakuten_integration_excel_marketplace_update.png 

Downloadable Template for Importing Listings

Related Articles

 

Back to top

 

The attachments from the Downloadable Template for Importing Listings 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.