When creating or editing products in Extensiv Order Manager, you can choose between two methods: manual creation in the UI or import via spreadsheet. To create a core product manually, follow the steps outlined below:
Navigate to the Products module, & click the New Product button.
2. Select Core Product
A core product is a single unique product that may be added into a bundle or kit. If the answer to this question: "Does the product I am selling contain an item within it that I order individually from my supplier?" is "no", then you have a core product.
When creating a Core Product, you’ll be taken to an edit window to fill out product info. There are three required fields here which must be entered before you can proceed:
You cannot create a Master SKUs that already exists, active or inactive
Dropdown fields with a blue plus sign or gear icon button next to them are fields that can have a new option added or edited, respectively.
The Special section at the bottom is for organizational purposes only. No special flow will occur if these boxes are checked or not, so you can choose to set them with a value or not.
Overview of all Product Fields:
The unique value used to identify the product in-house. Does not need to match the Listing SKU
Used to identify the product in Extensiv Order Manager.
Universal Product Code
Title of the product
Used to filter products from the left hand section
A tag placed on the item
Orderbots can used labels to automate certain actions.
Minimum Advertised Price
Max Shipping Cost
Cost of Goods Sold
Used to calculate your COGS for products without a vendor SKU
Used to calculate order weight
Height, Width, Length
Used to calculate order dimension
Copy and paste the image URL into the designated text box and click Add. We can only host live, public URLs. If the URL were to become dead, then we would no longer have an active image. If the URL links to a private page like a host site that requires a login to access it, no image will appear. Once you add all desired product images, click Save.
Associate the sales channels to the master SKU / product within Extensiv Order Manager. This way, regardless of which channel you sell on, you calculate one sales velocity based on the sell-through of the Master SKU and not the listing SKU.
Click New Listing SKU, select the channel and enter the appropriate Listing SKU.
Fulfillment latency days is the lead time to ship out your orders. If left blank, it will be left at Amazon’s or Walmart’s default time period of 1-2 business days. However, if a specific integer value is inputted, it will appear on Amazon with a message like: "Processing takes an additional 4 to 5 days for orders from this seller.”
Push Extensiv Order Manager inventory to this listing is to specify if the listing SKU is FBA or FBM.
If the SKU is FBA, we do not need to push inventory to the listing. It will actually create ghost listings*. If the SKU is FBA, unselect push inventory. You can also utilize this for SKUs you don’t want to push inventory to.
*If ghost listings occur, the listing will have to be toggled from FBA to FBM back to FBA. This can also be done in bulk using the inventory import. This must be done on Seller Central
Adding vendor SKUs in Extensiv Order Manager is necessary especially because it will serve as the foundation for your profitability within analytics, although this is not the only way to calculate profitability. Your COGS within Extensiv Order Manager is calculated by either your vendor products or the UI (refer to images). The one thing you cannot do in Extensiv Order Manager without having vendor SKUs is create purchase orders
Add your vendor SKUs to your products. Before you can do so, you will need to have inputted vendors in the Settings Tab. Click New Vendor Product.
If you order the same product from more than one vendor, make sure to set up multiple Vendor Products and indicate one as the Default Vendor Product by selecting it and clicking the Default button. If you only have one Vendor Product for a Master SKU, it will automatically be set as the Default by Extensiv Order Manager.
NOTE: Extensiv Order Manager will only generate automatic Purchase Orders for the Default Vendor Product.
Select the vendor that the Vendor SKU is associated to.
Type the vendor SKU assigned to the master SKU. Remember that this SKU will appear on the purchase order
Minimum Order Qty
How many units need to be ordered in order to purchase this item from your vendor?
You cannot purchase 1 unit of chapstick, a minimum order of 100 is required
Time it takes from placing a purchase order to when you receive the unit(s) at your destination warehouse
How Extensiv Order Manager should round the number of units for order in an Auto PO calculation. Round Up will round up to the next Unit of Measure quantity exactly, Round Properly will round to the nearest Unit of Measure quantity, whether that is up or down, and Exact will not round at all.
Say you have a product that can be ordered in Cases of 12 units, but Auto PO generates with a requested quantity of 50
5 Cases (60 units)
4 Cases (48 units)
4 Cases + 2 Eaches (50 units)
If your products require special packaging, you can specify that here
As you purchase higher volumes of product, the vendor may provide you with better rates.
If a customer does not have pricing tiers, then simply add an arbitrarily high range (ex. 1 - 100,000 = 5.00)
001 - 099 = $5.00 / unit
100 - 999 = $4.50 / unit
Units of Measure (optional)
Only needed if your vendor allows you to order product in a UoM other than units/eaches, such as cases, cartons, pallets, etc.
Case = Qty 12
Carton = Qty 60
If you ship products overseas, your products will require customs information. If you would like Extensiv Order Manager to pre-populate customs declarations for international and APO/FPO customs forms for this product, please check the "Include Customs Declaration" check box below and enter the required declaration values.
If you do not enter customs declaration presets for this product, you will have to manually enter customs declarations for all orders that contain this product.
Brief explanation of product
Universal System/code to determine how much duty is needed to pay on the item
The origin of the product. Require to determine how much duty is needed to pay on the item
Cost of the Item