Newegg.com Publication and MapID Linking

Steps for Newegg1P Publication

1. Go to Feeds in Quipt
2. Filter channel com, qty 5+, recovery $50+, statuses Exported and Pending Export (minimum qty and price required for Newegg.com)
3. Click Export at top right in Quipt
4. Delete all columns in excel file except for SKU
5. Again in Quipt, go to Feeds
6. Filter channel NeweggMP, status Published
7. Click Export at top right in Quipt
8. In Excel, copy all the SKU line items from your first file, to below the SKU line items in the second file.
9. Select Conditional Formatting > Highlight Duplicates
10. Go to filters, and filter for everything that is not highlighted. Delete these line items from the Google sheet. These are items still waiting on NeweggMP publication before Newegg.com can match against the NeweggMP Item# in order to publish
11. In your second excel file, delete all the remaining SKUs you added from the first sheet. This should leave only those which are ready for publication on Newegg.com, and include a NeweggMP Item# in the Map ID column
12. Using the Condition Column, filter so only anything “NOT” New is showing. Add a -RFB suffix to all of the SKUs. You can now clear your filter so everything is again showing
13. Delete all columns, except for SKU and Map ID
14. Save the file, and send to your Newegg.com content creation contact. Ask them to map and activate the items using the NeweggMP item# in the file to match against.
15. Once your contact confirms items have been mapped and activated, go to your Newegg.com vendor portal (https://vendorportal.newegg.com/login)
16. Go to Item Management (left side of the screen) > Item Processing
17. At the top left, click Export all to excel
18. Open the file once downloaded
19. Delete all columns except for Vendor Part# and NE Part# (minimum necessary columns)
20. Change the field names from Vendor Part# to PartNumber and NE Part# to ABSItemNumber
21. Save file as a .xslx workbook
22. Email file to [e-mail] and in the subject line put the Name of your organization (e.g. WeeklyCloseouts, PCW, or HubX)
23. Within 30 minutes map IDs should be ingested into Quipt for your Newegg.com product feeds