Miva Merchant 5.5 Attribute Level QOH Synchronization

In this Topic: Show


Miva Merchant Version 5.5 provides a limited ability for the user to perform Inventory Synchronization at the attribute level (real-time inventory tracking) without the need for a third-party add-on product. This feature is not suitable for all users, and requires the v3.518 export module, at a minimum. Please be sure to read and understand the information in this topic before implementing this feature.

Miva Merchant v5.5 Attribute Level Inventory Synchronization

Steps to perform in Stone Edge

  1. Set the BuildSubSKUDelimiter parameter in Stone Edge to the underscore character “_”. Currently Miva Merchant does not permit user defined delimiters in their Variant SKU (SubSKU) built by their automated system. Miva has stated that they will add a user definable delimiter in the near future at which time the delimiter specified at Miva would also need to be set in the BuildSubSKUDelimiter parameter in Stone Edge.

  2. Set the BuildSubSKUs system parameter to TRUE to have Stone Edge build SubSKUs at order import from the shopping cart.

Steps to perform at the Miva Merchant Shopping Cart

  1. Set up the Parent SKU in Miva with the appropriate Attributes and Options. Keep in mind that the full value present in the Option’s Code field will be the value appended to the Parent SKU by Miva’s automated variant build system. As Miva does not support Stone Edge’s WebOptionCodeDelimiter or WebOptionProductDelimiter features, do not add additional delimiters to the Option’s Code Field in Miva. If you need to utilize these options in Stone Edge then you must use a third party inventory tracking system with Miva such as Viking Coders Inventory Manager.

  2. Use Miva’s “Auto Generate” option under the Inventory Variants tab to build the SubSKUs. Select either Pricing option for the SubSKUs (calculated by parent/attribute or fixed at the variant). Miva will generate the appropriate SubSKUs using an “or” methodology which results in more SubSKUs than Stone Edge will generate. For example:

A Parent SKU with three sizes and three colors will generate nine SubSKU variations in Stone Edge, however, Miva Merchant will generate fifteen SubSKUs. The additional six SubSKUs represent three sizes with no color selection and three colors with no size selection – impossibilities in the variant world. Variants that do not represent actual products should be removed from the variant list and Miva’s Products list as Stone Edge will not support these types of variations.

  1. Set up the QOH of the SubSKUs in Miva Merchant prior to exporting products to Stone Edge.

Complete the setup process in Stone Edge

  1. Import products from Miva into Stone Edge using the Import Inventory feature in the Shopping Cart Functions screen. The product import will not bring in the SubSKUs as part of the download, however, it will bring in any SubSKUs built in Miva that are no longer flagged as a variant – assuming they remain in Miva’s Products table (see step #3 above).

  1. Use Stone Edge’s Build SubSKUs option to create the SubSKUs in the Stone Edge’s Inventory. Pricing for the SubSKUs during the build is assumed from the parent SKU and the option price modifier(s) defined at Miva. Once the SubSKUs are created, manual adjustments can be made to the SubSKU’s price. Keep in mind that Stone Edge cannot refresh SubSKU prices from Miva, so any price changes applied in Miva must be repeated in Stone Edge.

  2. Once the SubSKUs are built, return to the Shopping Cart Functions screen to pull in the QOH from Miva using the Get QOH from Miva feature.   

  3. Quantity on hand synchronization will now operate between Stone Edge and Miva, provided the SubSKUs appearing in Stone Edge match up with those in Miva Merchant.

Additional Considerations

Miva Merchant Kits:

  1. Stone Edge can be set up to handle kits defined in Miva Merchant, however, it is a tedious proposition. A kit is defined in Miva Merchant by first identifying the Kit SKU (Parent) and a set of attributes and options – similar to variants. Once the Variant SKUs (SubSKUs) are built, the user can assign a list of parts to each of the SubSKUs effectively defining a “kit”. The assigned parts can be regular products or variants but must not contain other kits as this concept is not supported in Stone Edge.

  2. The product download to Stone Edge does not support kits so will not automatically create kits in Stone Edge’s inventory. This must be done manually by the user after building SubSKUs in Stone Edge. Once the SubSKUs are built, assign the parts list to each SubSKU that represents the kit part list for that variation.

  3. At order import, Stone Edge will receive the Kit SKU (Parent) and the selected options from Miva. The system will build the SubSKU then review the SubSKU to see if it represents a kit. If so, the system will add the parts list that is defined in Stone Edge’s inventory system. Do keep in mind that any changes to a kit’s part list in Miva must be duplicated in Stone Edge’s inventory.

NOTE: As Kits are virtual products, quantity on hand for the kit’s Variant SKU is not performed. QOH is adjusted only on the parts that make up the actual kit.



Created: 9/19/14

Go to Top