SUPPLY-Commerce7 Integration

InnoVint's SUPPLY product aims to provide a single source of truth for your case goods inventory, and we all know that double-entry leads to mistakes and extra work.  The integration with Commerce7 (C7) is built to support this aim.

This article covers:

• What does the SUPPLY-C7 integration do?
• How to connect your SUPPLY account with Commerce7
  • Things to know before you start
• How SUPPLY updates C7
• How C7 updates SUPPLY
• Editing Integration actions
• FAQ

What does the SUPPLY-C7 integration do?

The SUPPLY-C7 integration works in both directions (SUPPLY <-> C7). SKUs within taxpaid locations in SUPPLY are mapped and linked to locations and products in Commerce7. 

When orders are placed in Commerce7, they automatically deduct from SUPPLY inventory locations upon fulfillment.  As inventory is replenished in SUPPLY locations, it instantly updates in Commerce7 — no manual entry needed.

How to connect your SUPPLY account with Commerce7

Things to know before you start

Inventory across the systems will be tracked in their respective units.  C7 will always be tracked in bottles and SUPPLY will always be tracked by the format and grouping of the SKU.  The integration will "convert" the inventory between the two platforms automatically.

• Types of locations and SKUs that can be linked
  • ONLY taxpaid locations in SUPPLY may be linked to C7 locations

• C7 Product and SUPPLY SKU facts
  • The C7 product displayed in SUPPLY menu dropdowns is the “SKU” value from the C7 product setup
  • C7 products must only have one variant (i.e. 750ml OR 1.5L) in order to appear in the SUPPLY SKU C7 product dropdown 
  • Only one C7 product may be linked with each SUPPLY SKU 
  • Only one SUPPLY SKU may be linked with each C7 product
  • Only one C7 instance may be linked to SUPPLY
• Inventory parameters
  • Inventory must match between C7 and SUPPLY in order for a SKU with inventory to be linked between SUPPLY and C7. If the SUPPLY SKU has no inventory and the C7 product does have inventory when the product is linked, then the initial onboard/add inventory action for the SUPPLY SKU will override the inventory amount in C7 for that location. If the SUPPLY SKU and C7 product both have inventory, and it doesn't match, then the SKU linkage will fail. 
  • The inventory in SUPPLY for a SKU at a linked location is equal to the C7 inventory quantity in 'Available for sale' PLUS the inventory quantity in 'Allocated.'  The inventory in SUPPLY does not account for inventory quantity in 'Reserved.'
    • When initially linking a SUPPLY SKU with a C7 product, the inventory quantity in SUPPLY must equal the sum of the inventory quantities in 'Available for sale' and 'Allocated' in order for the SKUs to link properly.
  • If a C7 product does not have Inventory turned on, it will not show in the SUPPLY drop-down

Step 1 - Install the InnoVint App

Get started by installing the InnoVint SUPPLY app in your C7 platform. Check out the quick how-to video below!

Step 2 - Link Locations

A working integration requires that your inventory locations in C7 be mapped to taxpaid locations within SUPPLY. Only inventory within linked locations will update between the systems and these locations in SUPPLY must be taxpaid. 

First, create (or confirm the existence of) inventory locations in Commerce7.

Next, map these locations to your locations in SUPPLY. InnoVint Support sets up this connection on the backend - please provide your list of C7 inventory locations mapped to SUPPLY locations via support@innovint.us. These relationships should be created at the same you set up your SUPPLY account, or if you need to add or update these at any point, reach out to us. Have a long list? Use the location tab on this csv template.

Is your location already linked?

In order to see if a location has already been linked, you need to check in SUPPLY.  The linkage is not visible in C7. 

Linked locations in SUPPLY are noted by the C7 logo next to locations in menu dropdowns (in actions) and the Inventory by location widget in the SKU details page. 

Step 3. Link the SUPPLY SKU to a Commerce7 Product

You can link your SUPPLY SKUs to a C7 product either at SKU creation, or later on, by editing the SKU. 

Link at SKU creation

When adding the SKU, just check the box:

When you check the "Link to a C7 product," you will see a dropdown menu of available C7 products to link. You must select a product from the dropdown - you cannot create a new one via SUPPLY.

Link after SKU creation

Go to "Edit C7 Product" in the SKU details page via the More menu on a previously created SKU:

You'll see the same Edit C7 Product screen that will allow to link to a new product, or unlink/edit an existing product.

A successful linkage for a SKU will show the C7 product linked in the SKU attributes. A linked inventory location and any linked inventory actions will show the C7 logo on the SKU details page:

How SUPPLY updates C7

Once a SKU and location in SUPPLY are linked to a product and inventory location in Commerce7, inventory actions recorded in SUPPLY are reflected via inventory transactions on inventory in Commerce7.

All inventory actions in SUPPLY will display in the Inventory Transaction report in C7, with the following information. 

• Details: Manual reset of ‘SKU’ 
• Notes: Inventory transaction performed by InnoVint SUPPLY integration

• Add or onboard inventory in SUPPLY on SKU A in Location B 
  —> Inventory transaction in C7 to adjust inventory up for Product A in Location B by the appropriate number of bottles
• Move inventory in SUPPLY on SKU B from Location C to Location D 
  —> Inventory transaction in C7 to transfer inventory for Product B from Location C to Location D by the appropriate number of bottles
• Deplete inventory in SUPPLY on SKU C from Location E 
  —> Inventory transaction in C7 to adjust inventory down for Product C in Location E by the appropriate number of bottles
• The integration from SUPPLY to C7 updates in real-time ✅

Inventory actions in SUPPLY are recorded as of a point in time, and maintain a concept of the event "stream in time". Users can edit and delete actions in SUPPLY virtually without restriction. Any transactions or edits in SUPPLY (even past actions) will be applied to current inventory in Commerce7.

Back to top

How C7 updates SUPPLY

Once a SKU and location in SUPPLY are linked to a product and inventory location in Commerce7, inventory transactions on C7 products in linked locations will record an action in SUPPLY on the linked SKU. Three types of transactions in C7 will reflect in SUPPLY: Adjust inventory, Transfer inventory, and Fulfillment. 

Overview

• Adjust inventory transaction in C7 on Product C in Location D: 
  —> Add inventory OR Deplete inventory action in SUPPLY for SKU C in Location D (depending on whether inventory is going up or down).
• Transfer inventory transaction in C7 on Product E from Location X to Location Y: 
  —> A Deplete inventory action in SUPPLY for SKU E from Location X and an Add inventory action for SKU E at Location Y.
• Depletions due to order fulfillment in Commerce7 on inventory in a linked location
  —> If the inventory on the order is for a Product/location linked to a SUPPLY SKU/location, that will trigger a ‘Deplete Inventory - Sale’ action in SUPPLY.
• The integration from C7 to SUPPLY updates every 5 minutes ✅
• Submitted actions in SUPPLY that are a result of an inventory transaction in Commerce7 will show the user as “C7 Integration” with the C7 icon.
• Actions in SUPPLY that are completed by the C7 integration are not editable, but are deletable. 

• Reset inventory - in C7 this sets the absolute number for bottle count of inventory for a product in a location (can set available for sale and reserve counts). This action will not update in SUPPLY, and the overnight inventory will again override any C7 inventory discrepancies. 
• Adjust inventory - increase/decrease inventory bottle count for a product in a location. This action will reflect as either an Add inventory OR Deplete inventory action (depending on whether inventory increases or decreases).
• Transfer inventory - moves inventory from one location to another. This action in C7 creates a deplete inventory action and corresponding add inventory action in the respective locations.  
• Turn inventory off - if this is selected, use cannot view inventory or record inventory transactions in C7 - in this case, SUPPLY actions will have no effect on this product while inventory is off.

Back to top

Editing Integration actions

You may edit or delete any actions submitted by a SUPPLY user, but not actions submitted by the integration

• Editing an inventory action in SUPPLY that affects inventory at a C7-linked location(s) triggers a new inventory transaction in C7 to bring current inventory to the correct quantity
• That C7 inventory transaction will update current inventory and will be recorded in Commerce7 in real-time (it will not be backdated to match the original SUPPLY inventory action date)
• You may delete actions recorded in SUPPLY by the C7 Integration. This will also result in a corrective inventory transaction in C7. 

Note: Inventory transactions in Commerce7 are also recorded as of a point in time but the user cannot backdate, edit, or delete them. 

FAQ

Q: I've turned Inventory Off in C7 - what will that do?

A: Nothing should change with your SUPPLY inventory, but it will no longer synch with the C7 product. 

Q: I can't see the C7 product in the dropdown

A: The Product dropdown displays with all Commerce7 products that:

• are not already linked to another SUPPLY SKU
• have Inventory turned on (in C7)
• have only one product variant in C7

Q: I have more than one C7 account - how do I link to the correct version?

A: Currently, SUPPLY only support linking to a single C7 account. 

Back to top