↑↓ selectEnter openEsc close

    1. Elbuz
    2. US marketplaces

    How to connect Newegg to Elbuz: orders, prices and stock, new products

    4 min readUpdated

    Elbuz connects to your shop on Newegg (Newegg.com, Newegg.ca, Neweggbusiness.com) with your seller keys: it imports and confirms orders, links your products by SKU, and sends prices, stock, new products and shipments to the marketplace.

    When you need this:

    • You want to process Newegg orders in Elbuz: they arrive as documents and are confirmed on the marketplace.
    • You calculate prices and stock in Elbuz: the export sends them in a feed.
    • You want to list new products: Elbuz creates an item or an offer on an existing Newegg item.

    Where to start: enter the Seller ID and SecretKey in an import template of type “Newegg” and run the catalog import.

    What the Newegg connection can do

    What to get from Seller Portal

    The Seller ID and SecretKey are issued by your Newegg seller account (Seller Portal) when you grant access to the integration. Requests to Newegg are also signed with a developer key: enter it in the “Your own developer key” field. Without the key, the import stops with “Newegg: Seller ID, SecretKey or developer key is missing”.

    The “Connection” card of the Newegg import template
    1Seller ID
    2SecretKey
    3Marketplace
    4Stock warehouse
    5Your own developer key
    1. Seller ID — the seller identifier from Seller Portal.
    2. SecretKey — the seller secret key.
    3. Marketplace — US, CA or B2B; can be picked from the list.
    4. Stock warehouse — the warehouse country code, Newegg.com only.
    5. Your own developer key — the key that signs requests to Newegg.
    Template fieldWhat to enter
    Seller IDYour seller ID. Required
    SecretKey (seller secret key)The secret key. Required
    MarketplaceUS, CA or B2B; the “Pick from list” button fills in the code. Empty means US
    Newegg.com stock warehouseThree-letter country code of the warehouse. Newegg.com only; empty means USA
    Your own developer keyYour Newegg developer key

    The marketplace currency is US dollars for Newegg.com and Neweggbusiness.com, and Canadian dollars for Newegg.ca. Elbuz doesn't convert prices.

    “Active” and “Orders” are already on in a new template: 5 minutes after you save the keys, Elbuz starts fetching and confirming orders from the last 30 days. Elbuz maps marketplace statuses to yours automatically, by name; the template's “Order statuses” window shows what came in and how it was mapped. Want to check first? Clear “Orders”.

    The methods Elbuz uses are described in the Newegg Marketplace API.

    How products are linked to Newegg

    The catalog import doesn't create products in Elbuz; it only links your Newegg items to existing cards. Newegg returns the item list as an inventory report with no names, only your SKU (Seller Part #) and the Newegg item number. Elbuz looks for a card whose SKU matches the Seller Part # and remembers the link.

    The marketplace takes a few minutes to prepare the report. Elbuz requests it and waits about a minute:

    What's in the logWhat it means
    “Newegg: inventory report ‹number› requested”The report has been requested
    “Newegg: report ‹number› is still being prepared (‹state›), the result will come with the next run”A minute wasn't enough; the next run picks up the same report
    “Newegg: report rows: N, linked to products: M, not found by SKU: K”The result. K above zero means Elbuz has no cards with those SKUs

    Elbuz skips any item not found by SKU. Give the card the same SKU as the Seller Part # on Newegg and run the import again.

    How orders arrive and get confirmed

    An order arrives as an unposted “Customer order” document. The first import takes orders from the last 30 days. After that, it filters by order date with a 7-day margin: Newegg has no filter by modification date, and an older order's status may have changed. An existing order is recognized by its number and updated.

    Elbuz fetches and confirms orders itself every 5 minutes if “Orders” is checked and the keys are filled in. The shared “Marketplace orders” task in the “Job schedule” window does this; the interval is set there. The template schedule (“Schedule setup”) only links the catalog: run it rarely, say at night — the orders pass is skipped while it runs.

    Once a new order is saved in Elbuz, it is confirmed on the marketplace as received by the seller. If that fails, the log shows “Newegg: order ‹number› was not confirmed — ‹reason›”. The summary reads “Newegg: orders imported: N, confirmed on the marketplace: M”.

    Amount in the Newegg orderWhere it goes in the document
    item priceline price
    order discountspread across the item prices in proportion to their amounts
    shippingthe document's shipping cost
    sales taxnot included in the total: the marketplace collects and remits it itself

    Document lines are linked to products by Seller Part #. Canceled items don't go into the document if the order has other items.

    Order statuses

    Elbuz maps the marketplace status to yours by itself — by code or name, and an unrecognized one becomes “New”. You can adjust this with the “Order statuses” button on the import template's “Related settings” card: in the “Code (name) on site (API)” column, enter the Newegg status next to your status.

    Newegg statusWhat it means
    UnshippedNot shipped
    Partially ShippedPartially shipped
    ShippedShipped
    InvoicedInvoiced, closed
    VoidedCanceled

    For sending to the marketplace, mappings use the codes SHIPPED and VOIDED; see shipments. What happens to a posted order and its reservation is covered in importing orders via API.

    How prices and stock go back to Newegg

    The reverse direction is a separate export template of type “Newegg” with two fields: Seller ID and SecretKey, the same as in the import template. The export takes the marketplace, warehouse and developer key from the import template with the same Seller ID.

    The “Connection” card of the Newegg export template
    1Seller ID
    2SecretKey
    1. Seller ID — the same as in the import template.
    2. SecretKey — the same secret key.

    Products linked to Newegg are updated. Prices and stock go in one feed per run, up to 10,000 rows per file; for Newegg.com, price and stock go in two feeds. The marketplace takes a few minutes to process a feed:

    What's in the logWhat it means
    “Newegg: feed ‹number› (‹type›) sent, rows: N”The feed has gone to the marketplace
    “Newegg: feed ‹number› is still being processed (‹state›), the result will come with the next run”The next run picks up the result
    “Newegg: feed ‹number› processed — succeeded: N, errors: M”The feed result
    “Newegg: “‹name›” (‹SKU›) rejected: ‹reason›”The marketplace didn't accept the row

    Newegg counts its feed limit per hour, so exporting once an hour or less often is a sensible schedule. If a request is refused over the limit, Elbuz waits and retries; if that doesn't help, you'll see “Newegg: marketplace request limit exceeded, try again later”.

    New products on Newegg

    A new-product feed holds up to 3,000 rows, and up to 5 feeds go per run; the rest go with the next run.

    With the “Publish new products” checkbox, an unlinked product goes to Newegg in a new-product feed. What gets created depends on whether the product's category is mapped to a Newegg subcategory (the Newegg tab in the mapping window):

    The product's category isWhat Elbuz createsWhat the product needs
    mapped to a Newegg subcategorya new Newegg itemname, short and full description, weight, photos (up to 7) and the subcategory's required properties
    not mappedan offer on an existing Newegg itema UPC/EAN barcode or manufacturer part number (MPN)

    Both cases need a SKU (it becomes the Seller Part #, up to 40 characters, no duplicates), a manufacturer that exists on Newegg, and a UPC/EAN or MPN. The product goes as new, with price and stock from the export template.

    Elbuz takes the subcategory's required properties from product attributes with the same name: the “Costume_Brand” property finds a “Costume Brand” or “Brand” attribute, and the brand comes from the product's manufacturer. Elbuz doesn't make up values the product doesn't have.

    What you see in the log

    • Something is missing: “Newegg: “‹name›” — item not created, missing: ‹fields›”. Elbuz retries such a product a day later, so add what's needed in the meantime.
    • While the marketplace is processing a new product, later runs skip it: “Newegg: new products still being processed by the marketplace: N”.
    • Accepted: “Newegg: product “‹name›” (‹SKU›) is on sale”, and the product is linked.
    • Per run: up to five new-product feeds; for the rest, “Newegg: item feed limit per run reached, the remaining products (N) go with the next run”.

    Shipments and cancellations

    The “Orders” checkbox in the export template sends two events to Newegg:

    Your status is mapped toWhat Elbuz sends
    SHIPPEDShipment of all items not yet shipped as one package, with tracking number and carrier
    VOIDEDCancellation with the reason “Unable to fulfill order”
    • Tracking number: the “Delivery service: number” field on the document's “Delivery” card (expand “More fields”). If it's empty: “Newegg: order ‹number› has no tracking number”.
    • Carrier: the Newegg carrier code (UPS, FedEx, USPS…) mapped to the delivery service with the import template's “Delivery types” button. Without a mapping: “Newegg: order ‹number› — map the delivery service to a Newegg carrier in the template delivery settings”.

    Each event is sent once. Orders already shipped, closed or canceled on the marketplace aren't sent. The log shows “Newegg: order ‹number› → SHIPPED” and the summary “Newegg: order statuses sent: N, errors: M”.

    Scenarios

    Connect a shop that already sells on Newegg

    What to turn on. An import template with your keys and the “Products” and “Orders” checkboxes. Make sure the SKUs of your Elbuz cards match the Seller Part # on Newegg, and run the import twice, a few minutes apart, to pick up the finished report.

    What you get. Newegg items are linked to your cards, and orders arrive as documents by themselves every 5 minutes. Then an export template with “Products” updates prices and stock, and with “Orders” sends shipments.

    List new products

    What to turn on. For your own products, map categories to Newegg subcategories and add attributes named after the required properties. For products already sold on Newegg, a barcode or MPN is enough. In the export template, turn on “Publish new products”.

    What you get. Products with complete data go to Newegg; for the rest, the log lists what's missing and Elbuz retries a day later.

    What to do when Newegg won't send or accept data

    Common problems
    What you seeWhyWhat to do
    “Newegg: Seller ID, SecretKey or developer key is missing” One of the three fields is empty Fill in the import template fields (what to get from Seller Portal)
    “…not found by SKU: K” Elbuz has no cards whose SKU matches the Seller Part # on Newegg Enter the SKUs and run the import again (linking)
    “…still being prepared…” or “…still being processed…” The marketplace didn't finish within a minute Nothing: the next run picks up the result
    “Newegg: “…” — item not created, missing: …” The product lacks required fields Fill in the listed fields; Elbuz retries a day later (new products)
    “…map the delivery service to a Newegg carrier…” The document's delivery service has no Newegg carrier code Map it with the import template's “Delivery types” button (shipments)

    FAQ

    I ran the catalog import, but no new products appeared in Elbuz. Why?

    The Newegg report has no names, so Elbuz doesn't create products; it only links existing ones by SKU (linking).

    Why is the order total lower than what the customer paid?

    Newegg collects and remits sales tax itself, so it isn't included in the document total (orders).

    I sell in the US and Canada. One template or two?

    Two: each marketplace has its own keys and currency (where to find it).

    Other sellers already sell my product on Newegg. Do I have to describe it from scratch?

    No. Don't map its category to a Newegg subcategory, and Elbuz will list an offer on the existing item by barcode or MPN (new products).

    My catalog prices are in hryvnias. What goes to Newegg?

    The same number, without conversion. Prices in the export template's filtered set must be in the marketplace's dollars (currency).

    Where to find it and who has access

    Menu
    Directories → Operations → Data import → new template of type “Newegg”
    Other entry points
    Directories → Operations → Data export: a template of the same type; subcategories: the marketplace category mapping window
    Access right
    the “Import” window in “Group permissions”
    Have ready
    your Newegg Seller ID, SecretKey and developer key

    One template, one marketplace. If you sell on both Newegg.com and Newegg.ca, create two templates, each with its marketplace's keys.

    Related topics

    Was this article helpful?

    Missing a feature? Tell us.

    We will add it for free if other users need it too.

    If only you need it, we will agree on it separately.

    Article contents

    Suggest an improvement

    Try Elbuz free