Commerce7 Integration

Follow

Commerce7 – FORT integration

Orders originating in Commerce7 can be synched with FORT.

To connect to a Commerce7 account, make sure a "Remote Upload Key" is entered on the Company page. It can be found in the "Integrations(s)" section.

A company or marketing code can be connected to a Commerce7 account using a FORT app in Commerce7.

Go to the App store within Commerce7 and search for "FORT Systems" or “FORT Ship”, and click to Install (make sure to install only 1 of the apps, not both).

Two fields will display: "FORT Company Code" (required) and "FORT Marketing Code". Enter the "Company Code" of the company you are trying to connect to (The code can be found in the Company Profile section on the company page.) If you want to connect only at the company level, do NOT enter a Marketing Code. (The "FORT Marketing Code" field is NOT required.).
Enter a code only if you are trying to connect your account for a Marketing Company. FORT will search to see if the company found with the "FORT Company Code" has a Marketing Code that matches the entered code. If no Marketing Company exists for the set Marketing Code, FORT will automatically create a Marketing Company, Marketing Code, the "Remote Upload Key", and a FORT client user.

 

 


After a Commerce7 account is connected through the app, you can update the following setting fields if desired: Order Delivery Method, Fulfillment Date Type, Time Zone set in Commerce7, Check Address, RSD Required, Flag Errors, Send Transaction Email, and Default Service Level (The Default Service Level setting is essentially a backup that is used for a package's service level if the shipping code found in Commerce7 does not match a FORT service level code.)

All of the FORT service level codes can be found here:

https://support.fortsystems.com/hc/en-us/articles/218194088-Carrier-Service-Levels

To set the code in Commerce7, go to Settings -> Shipping, and then click on the appropriate Shipping Zone. The Shipping Services for that zone will then be listed. 

Edit the appropriate Shipping Service and change the value for “Code” to match the desired service level code in FORT:

 

  • Order Delivery Method: The options for this field are “Ship”, “Pickup”, and “Carry Out”, with “Ship” being the default. FORT will look only for Commerce7 orders that have an Order Delivery Method found in the set list on FORT. If Pickup orders are set to upload into FORT, the Pick Up address will be set for the Recipient Address, and the service level will be set to WCP. If Carry Out orders are set to upload into FORT, the Carry Out address will be set for the Recipient Address, and the service level will be set to DPL.
  • Fulfillment Date Type: The options for this field are “Print Date” and “Depletion Date”, with “Print Date” being the Default. This field determines when Fulfillment info is sent back to Commerce7 for a FORT package - after the package has been Printed or Depleted.
  • Time Zone set in Commerce: The default for this field is “America/Los_Angeles”. Have this field match the time zone set in Commerce7. This will ensure that dates like the Requested Ship Date will be imported correctly into FORT.
  • Check Address: The setting whether to check recipient address when uploading into FORT. If turned off, FORT will assume all addresses have been verified.
  • Requested Ship Date (RSD) Required: If set to “Yes”, FORT will upload only C7 orders that have an RSD set. When determining the RSD, FORT will first look to see if a RSD was set at Order creation within Commerce7. If no RSD had been set (or if you’d like to overwrite the C7 RSD), you can add an RSD tag. FORT will look for a tag with the format “RSD:yyyy-mm-dd”. 
  • Flag Errors: If this setting is turned on, orders that fail to upload into FORT will be flagged within Commerce7. This will make the orders with errors more obvious within Commerce7. The flags are also beneficial because FORT will ignore orders with FORT Error flags for 24 hours (this will prevent the orders from failing to upload over and over with the same errors). These flags will say “FORT Error mm/dd/yyyy hh:mm:ss”. Once the order has been successfully uploaded, the flag will be removed. If you know you have fixed the underlying issue, you could also manually remove the flag so the order will attempt to upload again the next time the scheduled task is run.
    To remove the flag manually, click the pencil next to flag in Commerce7. Then click on "More Actions"->"Delete"
  • Send Transaction Email: The setting to determine whether to send Commerce7 emails at Fulfillment.

You can use Commerce7 tags to add information to the FORT order. For example, if no RSD was set in Commerce7 (or if you’d like to overwrite the Commerce7 Requested Ship Date), you can add an RSD tag. FORT will look for a tag with the format “RSD:yyyy-mm-dd”.  Similarly, you can add tags to set FORT upload data for Special Instructions, Delivery Instructions, and Gift Message. For example, if the tag “SI:Ice Pack” were added in Commerce7, “Ice Pack” would get set as the Special Instructions in the FORT order.


FORT will look for SI -> Special Instructions, DI -> Delivery Instructions, and GM -> Gift Message.
You can set Gift Message/Delivery Instructions at order creation in Commerce7 (there is a Gift Message field, and the Shipping Instructions field → Delivery Instructions in FORT). If those messages are found in addition to tags, the messages will be concatenated. For example, if Commerce7 has “Shipping Instructions” set to “Main Message”, and the tag “DI:Tag Message”, in FORT the delivery message would be set to “Main Message; Tag Message”.

C7 Tag functionality described here:   https://documentation.commerce7.com/what-are-order-tags-how-do-they-work

If there is a “POS Profile” set for a Commerce7 order (POS Profiles can be found in the C7 Settings area), the “title” (or name) of that Profile will automatically be mapped to a Process Group in FORT using that name.

 

If you uninstall the app in Commerce7, the setup FORT/Commerce7 connections associated with your tenant will be turned off.

A scheduled task will run every 30 minutes to attempt to upload Commerce7 Orders that are Not Fulfilled or Partially Fulfilled (i.e., not In Process at the FORT warehouse), and have been updated/created since the last successful upload. The system will check every morning on any previously unsuccessfully uploaded orders and will attempt to reupload them. If you don’t want to wait for the system to check orders, you can click on the update button to check for orders right away.

“Quarantined” orders are prevented from being Uploaded to FORT. Once such orders are no longer set to "Quarantined", they will attempt to be uploaded the next time the scheduled task runs. 

The system will stop trying to upload failed Commerce7 orders if they have not been updated in Commerce7 for over 30 days.

"In House” orders are prevented from being Uploaded to FORT. To create In House orders, use the C7 Tag functionality described here:   https://documentation.commerce7.com/what-are-order-tags-how-do-they-work.

Orders uploaded to FORT that are subsequently refunded in Commerce7 need to be manually deleted in FORT by a warehouse admin, or if still ‘pending’, then by the client itself.  FORT will not re-upload the Commerce7 Refunded orders after they are deleted in FORT. 

Commerce7's "channels" map to FORT Order types as follows:

C7 Channel >> Type - Subtype

Web >> Web

Club >> Club

Inbound >> Other - Inbound

Other >> Other

Marketplace >> Other – Marketplace

When customer Meta Data has the code “exemption-types”, it can be used to set the Order Type / Subtype. If it’s set to Wholesale or Trade, then the FORT Order Type is set to “Trade” and the FORT Subtype is set to “Wholesale”. If it’s not set to Wholesale or Trade, then the FORT Order Type is set to the Commerce7 channel name: Web, Club, Inbound, or Other, and in these cases, if the “exemption type” if set to Patio or Pours, then the Subtype would be Patio or Pours accordingly.

Use the Commerce7 Transaction Email-Yes/No in the Orders Integration C7 section of the company page to set whether or not the Commerce7 Transaction email is sent.  Please note FORT provides 3 options for this email in the Commerce7 integration area:  

  • “Yes (includes Will Call)”  (default)
  • “Yes (excludes Will Call)”
  • “No”

FORT allows the distinction between including and excluding Will Call orders here because some company's customers may find it confusing to receive tracking emails for Will Call packages which they may already have picked up.  

If the service level designated in C7 can’t be found in our system, FORT will use the Default Service Level set on the company page.

When the scheduled task runs, it looks for packages that are printed or depleted (depends on the setting for “Fulfillment Date Type” on the FORT company page), and a “Fulfillment” will be added to the Commerce7 order. (A “Fulfillment” is a package status update.)  There will be one “Fulfillment” for each package generated in Fort Systems, so if FORT splits an order into 3 packages, then there will be 3 separate “Fulfillment” records in Commerce7.

When a Package label is voided, the corresponding Fulfillment status update will be removed from Commerce7.

In the attached image you can see an example Commerce7 Order. There are multiple Fulfillment lists under the Fulfillment tab. There is one for each Package. Before any Packages are fulfilled, the Order’s Status is “Not Fulfilled”. After at least one package is fulfilled, but not all associated packages are fulfilled, the status will be “Partially Fulfilled”. Once all the associated packages are fulfilled the Order will be “Fulfilled”.

Commerce7 SKUs are case-sensitive

Commerce7's SKUs are case-sensitive, so if a SKU entered in FORT is different from that entered in C7, the tracking numbers for the packages with that SKU cannot be uploaded to C7 (as the SKU contents will not match).

 

 

 

Notes:

  • Splittable Virtual Kits cannot be used for C7 orders. If a splittable kit is uploaded, the system will generate an error: "Splittable Virtual Kits cannot be used for Commerce7 orders. Please update Item ID: kit_Id's "Splittable" field to No and then try to import again. Otherwise you will need to manually upload the order."
  • Commerce7’s system is case sensitive, even for SKUs. C7 doesn’t require using just caps or just lower case. You can any combination of caps or lower case letters, but however they are used, what is entered in FORT must match exactly what is entered in C7.
  • All orders that have not been modified in over 30 days will be ignored.
  • FORT imports products that don't have "Shippable Product" set to false. FORT does import C7's "Bundled Products" which are equivalent to FORT's "Virtual Kits", even if they have non-shippable products.

Note that Commerce7's platform does not capture the Recipient Email, and we do not anticipate that it will at any time soon. According to the Canadian-based Commerce7, Canadian privacy laws prohibit marketing to a recipient who did not place an order by him or herself, and thus, Commerce7 does not save recipient email data to ensure compliance with such regulations. Unfortunately, without this information, shipment status emails would not be sent to a recipient unless the recipient information is manually entered into FORT via a batch file or directly into the order detail page.

To try and work around this issue, FORT looks for Order Meta Data with the code “recipient-email” to set the Recipient Email in FORT. (The C7 client must set the code up in Commerce7).
https://documentation.commerce7.com/creating-custom-attributes-for-an-order
If no Order Meta Data was found for the Recipient Email, FORT uses the C7 Customer email for the FORT 'Ship-To' email.

 

Was this article helpful?
3 out of 3 found this helpful

Comments