Import Inventory Descriptions in bulk via an MS Excel File:
Detailed step-by-step instructions below, along with tips & suggestions at the bottom of this page.
In order to use MS Excel to bulk import your inventory, you must use the following process:
1.) Create your auction
2.) Click on the auction to enter the Auction Dashboard, and then go to the ITEMS tab
3.) On the Items page, click on the teal colored 'Lot Actions' button and then from the drop down menu select 'create inventory'. The system will prompt you to enter how many lots you will be adding. You can over-estimate the number of lots in the auction and discard unused items if needed. You can also come back at any time and add more items this way.
4.) Once you've used the 'create inventory' function, immediately you will see the new "blank" inventory items on the Items page. You can now click on the teal colored 'Lot Actions' button and click on the 'Download Inventory in Excel Sheet' option.
5.) The MS Excel sheet that will now auto download will be your inventory template for this specific auction.
6.) Required fields/columns are in red colored text. Add your item descriptions in Column O.
7.) Save your Excel sheet locally on your computer and then back in the admin panel, on the ITEMS page, click on the teal colored LOT ACTIONS button and select the 'IMPORT INVENTORY EXCEL SHEET' option and follow the steps to upload your MS Excel inventory sheet. The system will prompt you if the file was properly uploaded or if there were any issues.
IMPORTANT INFO:
The above steps are needed because all inventory items in MaxanetNext have unique SKU#'s and when you use the 'create inventory' function, this creates blank inventory items with these unique SKU#'s.
The MS Excel file that you download has built-in instructions in the 2nd sheet which can be found at the bottom of the document.
TIPS/SUGGESTIONS:
Adding Taxes/Fee's to an item level in the Excel:
You can add Fee's on the item level; these can be a Premium, a Tax, or a custom fee that will be attached on the item level.
To do this, in your admin panel, go to your Configurations: Global Fees page. The 3rd column has the 'Codes'. These codes will need to be copied and pasted into Column 'i' in your Excel sheet. Put a comma and space between them like this:
PMP15Y10R3, TXP8N0R2
Using Custom Column Headers in Excel:
In the Excel sheet, you can optionally use what we call 'custom column headers' which start in column Q. You can rename the header row for column Q for example to be 'Make' and change the column header in column R to be 'Model'
These 'custom column' headers will be displayed inside the item description on the public pages like this:
Make: Toyota
Model: 4Runner
VIN#: XYZ
Mileage: 12,323
Color: Black
It's a very handy way to have nicely organized/presentable item descriptions to your bidders. You can add unlimited additional custom column headers to your Excel sheet in columns V, W, X, Y, etc.