WholeCell's Newegg integration keeps your Newegg listing quantities synced with current stock levels from WholeCell, imports Newegg sales orders to WholeCell for IMEI fulfillment, and sends shipment tracking to Newegg.
This integration syncs:
Listings (Newegg → WholeCell)
Listing Quantities (WholeCell → Newegg)
Orders (Newegg → WholeCell)
Shipments (WholeCell → Newegg)
Enabling the Newegg Integration
First, you'll need to get an API Key from your Newegg Seller portal. Hover over your email at the top right of the page, go to Data Feed Settings > API Settings > Auth a Developer. If WholeCell appears as a Service Provider in Newegg's drop-down list, select it and use the key it generates:
Configuring the Newegg Integration
Order Import
WholeCell will import Newegg sales orders once this checkbox is selected. Older orders can be imported to WholeCell retroactively by selecting a date and time in the Minimum Order Date section.
Organization Type
When WholeCell imports new sales orders from Newegg it can create new customers in your WholeCell account based on their actual name (like "John Doe") or it can import them under a single customer named "Newegg". You can decide which option fits your business needs better.
Order Statuses
You need to map Newegg's order statuses to your WholeCell order statuses for orders to be imported. If you want to create new order statuses in WholeCell for this, follow the instructions in this article: Managing Sales Order Statuses.
WholeCell routinely fetches status updates from Newegg to update your Newegg orders. If an order is marked as shipped in Newegg, for example, it will update in WholeCell at the next sync interval. Changes to the order status in WholeCell will not affect the order status on Newegg.
Some actions like adding a shipment will sync back to Newegg and mark the order as shipped.
Inventory Quantity Sync
Enabling Inventory Quantity Sync will automatically update the quantities of your Newegg listings based on the calculated quantities* of connected Product Variations or SKUs in WholeCell.
* Calculated Quantity = Available Quantity - Outstanding Quantity
Inventory Statuses
With Inventory Quantity Sync enabled, select the inventory statuses that should count towards your total calculated quantity* of available inventory to update your Newegg listings.
Warehouses
With Inventory Quantity Sync enabled, choose which warehouse(s)' inventory should count towards your total calculated quantity* of available inventory to update your Newegg listings.
Importing your Newegg Listings
Once your settings have been saved on the Details tab, click the Listings tab and click "Import Listings" to bring in your listings from Newegg.
You'll see the table fill with your Newegg listings once they've been imported.
If your Newegg listing SKUs match your SKUs in WholeCell exactly, those listings will connect automatically, and you'll see a green "Connected" tag in the status column. Otherwise, it will show as "Not Connected".
Clicking on any listing title will take you to a page where you can see if the listing is mapped correctly to a SKU. This listing imported with a SKU that did not exist in our WholeCell product catalog in this demo account, so it was not automatically recognized and linked. You can choose to manually connect listings to a single SKU or multiple SKUs from your WholeCell product catalog.
You can also connect listings in bulk by uploading your product variations and SKUs in WholeCell, following the instructions in this article: Setting Your Product Variations and SKUs
Syncing Orders and Shipments
As you receive orders in Newegg, they will be automatically created in WholeCell. When you add shipment tracking information to those orders in WholeCell, the tracking number will automatically sync back to Newegg.
If you're using ShipStation to create shipping labels for your Walmart orders, you'll want to connect ShipStation to WholeCell so that your Walmart orders flow as follows:
Newegg→ WholeCell → ShipStation
Then, when you create shipping labels for your orders, the tracking numbers will flow:
ShipStation → WholeCell → Newegg
**WholeCell will not be able to sync orders to ShipStation if your sales channels don't exactly match (case sensitive) the channel names that the integration uses -- like "Newegg", in this case. Changing these channel names will prevent the sync from working.
Important Notes or Reminders
When you enable 'Order Import' and receive orders with unknown SKUs, you won't be able to map different SKUs for the order item (e.g., mapping a WholeCell SKU to the channel's listing's SKU settings page in WholeCell). Even if you map the WholeCell SKU for that listing in WholeCell, the order item will still show "Unknown SKU". The only way to make those SKUs be recognized is to add them to the WholeCell product catalog. To proceed, you can either do a 'Direct Commit', or delete the order item and just commit whatever item you want to fulfill the channel order.
Troubleshooting
The listing quantities are not being updated
Has the listing been imported to WholeCell?
Is the listing connected?
Is the 'Enable Inventory Sync' box checked?
Is the warehouse set on the inventory items you want to sync?
If an order comes in and shows "Unknown SKU", check:
Are there matching SKUs in both Newegg and WholeCell?
Have all of your listings been imported to WholeCell?
If your orders are not coming into WholeCell, check:
Is the 'Enable Order Import' box checked?
Are your listings being set to out-of-stock even though WholeCell is actively syncing non-zero quantities? Check to see if you have other eCommerce software connected to the channel.
If you can't find the listing on the channel's settings page in WholeCell, make sure to search using the listing ID and not the SKU.