Lowes Account Integration

Overview

Lowe’s Home Improvement is a well-known US retail company that sells a wide range of products, including appliances, tools, hardware, electrical and plumbing supplies, lumber, building materials, and outdoor living essentials. Lowe's is widely recognized as one of the leading home improvement retailers, catering to DIY homeowners and professional contractors.

Integrating Lowe's into your Sellercloud account allows you to seamlessly import orders, upload tracking information, ensure your listings are always up-to-date with the latest inventory data, and more. This integration works through EDI documents, transmitting information between the two services via plugins and Scheduled Tasks. The document exchange goes through Rithum, previously known as CommerceHub. If necessary, you can open a ticket with Sellercloud Support to request additional customizations or other plugins for this integration. Any such modifications will be billable.

To have a dedicated representative complete the testing for your account and ensure that the setup is configured correctly, we recommend Premium Support.

You can also follow the instructions outlined in this article to integrate RONA (Lowe’s Canada) into Sellercloud. To integrate Lowe’s Marketplace, connect through Mirakl as instructed here.

Prerequisites

Before you can integrate Lowe’s into Sellercloud, complete the following requirements.

We recommend creating a Company where you will set up the Custom Company Settings and automate the plugins with Scheduled Tasks.

Rithum Support

Contact Rithum Support and request:

• A Supplier Test Plan and a Supplier Guide. Prior to production deployment, the entire test plan must be completed according to the documented procedures, including submission of a test transaction for each test order.

• Test and production credentials. Once you complete all test cases outlined in the test plan document, the platform will provide you with the production SFTP details: Server Name, Username, and Password. You will need them when setting up the scheduled tasks to automate the plugins. Also, make sure to obtain Belk’s ISA ID and Qualifier, and provide your Customer ISA ID.

Sellercloud Support

Open a ticket with Sellercloud Support and request that the following plugins be installed on your server:

• Lowes Order Import 850 with 997 – Imports orders from Lowe’s to Sellercloud in EDI 850 format and sends acknowledgement back in EDI 997.

• Lowes Order Export EDI 855– Sends order acknowledgment to Lowe’s in EDI 855 format.

• Lowes Order Export EDI 856 – Exports tracking information to Lowe’s in EDI 856 format.

• Lowes Invoice Export EDI 810 – Exports invoices to Lowe’s in EDI 810 format.

• Lowes Packing Slip PDF or Lowes CA Packing Slip PDF– Generates a printable PDF packing slip in a format that complies with Lowe’s requirements.

• Lowes Inventory Export EDI 846 – Exports inventory to Lowe’s in EDI 846 format.

• Lowes GS1-128 Label – Generates GS1-128 labels for Special Order Sales.

Custom Company Settings

Create the following Custom Company Settings. On your default company:

• STControlNumber
• GSControlNumber
• ISAControlNumber

ISAControlNumber, GSControlNumber, and STControlNumber can all start at 1. The tracking and inventory exports will increment this number accordingly as jobs are processed. If the settings already exist and have values in them, do not edit them.

On the company created for the integration:

• Lowes_CustomerISAID – Enter a phone number that is not in use for any other EDI integration.

• Lowes_ISAID – Contact Lowe’s for this setting's value. Usually, it’s 7047581000CH.

• Lowes_CustomerQualifier – Set to ZZ.

• Lowes_Qualifier – Set to 12.

• Lowes_VendorIDForSSCC – A 6 to 10-character code used as part of the SSCC (Serial Shipping Container Code) generation. The SSCC number uses the format 0000XXXXXXYYYYYYYYYZ, where:

  • 0000 are four zeros.
  • XXXXXX is the option.
  • YYYYYYYYY are the leftmost 9 characters after merging the Company and Package IDs.
  • Z is a redundancy check digit calculated by the plugin.

• RejectLowesUnknownSkus – When set to True, if an item comes in with an Unknown SKU, reject it with the reason bad_sku.

• RejectLowesOutOfStockItems – When set to True, if you don’t have an available quantity of an item, you reject the order and send a Rejection Reason "out_of_stock" or an Estimated Ship Date based on the EstimatedDaysToShipOutOfStockLowesOrders setting below.

• EstimatedDaysToShipOutOfStockLowesOrders – When this setting exists and has a valid value, and you don’t have an available quantity of an item for an order, you send an Estimated Ship Date based on the Order Date plus the number of days from this setting. If this setting doesn’t exist or doesn’t have a valid value, you don’t send an Estimated Ship Date and instead send a rejection reason "out_of_stock." The Order Acknowledgment plugin still works if one or more of these settings don’t exist.

• (Optional) Lowes_SetSOSOrdersOnHold – Defaults to False. Set to True to set SOS orders On Hold.

• (Optional) Lowes_SetGenericNoteOnSOSOrders – Defaults to False. Set to True to add this note to SOS orders: 'Order is SOS, order import plugin set it ON HOLD.'

• (Optional) Lowes_UNSP_ShippingService – Enter the shipping service code that must be assigned to orders with code UNSP. Example value: FEDX_CG or UPSN_CG.

• (Optional) Lowes_Lock_UNSP_ShippingService – Set to True to lock the service code from the Lowes_UNSP_ShippingService setting above.

• (*Optional) LOWES_ShippingRequiresThirdPartyBilling – *By default, this setting applies as True if it doesn’t exist, which means that orders will always be imported with Third-Party Shipping required. If you intend to use your own shipping account, create this setting and set the value to False.

• (Optional) Lowes_MatchByLowesSKUFirst – Set to True to match products in Sellercloud by the Lowes SKU Custom Product Column instead of the ProductID. This setting defaults to False if you don’t create it.

• (Optional) Lowes_SetCustomerServiceStatusOnOrderToRequiresAttention – Set to True to set the Customer Service Status on SOS orders to Requires_Attention. This setting defaults to False if you don’t create it.

• (Optional) Lowes_CanadaTaxPercentagesPerProvince – For RONA, enter a comma-delimited list of province - tax province combinations. For example: ON-10, QC-7, BC-5.

• (Optional) Lowes_ChannelsIDsForTaxPerProvince – Enter a comma-delimited list of Channel IDs for which tax per province should be applied to orders in Sellercloud. For example: 15, 6, 4.

• (Optional) Lowes_ReferenceIdentificationQualifier – If you add this setting and set it to lowesca or rona, the N1 segment in the Invoice Export EDI 810 will be filled differently than the default way (the N102 will be filled with lowesca instead of N103 and N104), and the REF segment will be sent, containing the following Tax Registration IDs, which must also be created:

  • Lowes_CGTaxRegistrationID - Required when Goods and Services Tax (GST) is applied.
  • Lowes_VATaxRegistrationID - Required when Harmonized Tax (HST) is applied.
  • Lowes_STTaxRegistrationID - Required when Quebec Sales Tax (QST) is applied.

• (Optional) Lowes_NetTermDays – The number of days until the total invoice amount is due. Defaults to 30.

• Lowes_InboundToParty – The value of the Reference Identification segment in the Inventory Export EDI 846, used to associate additional identifying information with an item record. Enter rona if you are integrating RONA.

• Lowes_Expected_Qty – If there's no quantity on hand for a product, this setting is exported as the quantity expected to become available by the date/time of the Custom Product Column EXPECTED_AVAILABLE_DATE. This setting defaults to 1.

• Lowes_LocationWarehouse – Use this setting to map Sellercloud warehouses to Lowe’s locations in this format: " 123-Code1;124-Code2" where 123 and 124 are Sellercloud Warehouse IDs and Code1 and Code2 are the LocationCode from Lowe’s.

• ExportMultipleWarehousesOnLowes846 - Set to True to export inventory quantities per warehouse using the mapping from the Lowes_WarehouseCodeMapping setting below.

• Lowes_WarehouseCodeMapping – Map Sellercloud warehouses to Lowe’s warehouse codes and set a Safety Quantity per warehouse. Use this format: {WarehouseID},{WarehouseCode},{SafetyQty}. For example:

  • If the WarehouseID in sellercloud = 123; WarehouseCode = California; Safety Quantity = 0

• If the WarehouseID in sellercloud = 234; WarehouseCode = Florida; Safety Quantity = 1

• Then the setting would look like: "123,California,0;234,Florida,1"

For the inventory export plugin to export the complete inventory across all warehouses, DO NOT add the ExportMultipleWarehousesOnLowes846 and Lowes_WarehouseCodeMapping settings listed above.

Custom Product Columns

Create the following Custom Product Columns:

• LOWES_SKU – The product’s SKU at Lowe’s. Set the Data Type to String.

• LOWES_VENDOR_SKU – Empty by default. If you populate it, it will be used as the product identifier in the Inventory Export’s line item information segment, and Sellercloud will send it as the Vendor SKU. Set the Data Type to String.

• EXPECTED_AVAILABLE_DATE – Set the date and time by which the quantity in the Lowes_Expected_Qty Custom Company Setting is expected to become available if there's currently no quantity on hand for a product. If this setting is not populated with any value, two months will be added to the current date. Set the Data Type to DateTime.

• (Optional) Lowes_Enabled – Enable only specific products for Lowe’s. Set to True for any products you want to send with the Inventory Export plugin. Set the Data Type to Boolean.

• LowesSafetyQty – A Safety Quantity for products on Lowe’s. To use this setting to set the Safety Quantity on the product level, you must set the {SafetyQty} in the Lowes_WarehouseCodeMapping Custom Company Setting to 0. Set the Data Type to Integer.

Custom Order Columns

Create the following Custom Order Columns:

• (Optional) IsShipToStore – Shows if an order is Ship-to-store. Set the Data Type to Boolean.

• IS_SOS_ORDER – The Order Import plugin changes this column’s value to True to show if an order is an SOS order. Set the Data Type to Boolean. Defaults to False.

• ProcessedForSSCCID – Defaults to False. It is automatically set to True on Non-SOS orders and SOS orders processed by the GS1-128 Label plugin. Set the Data Type to Boolean.

• Lowes_StoreNumber – Set the Data Type to String.

• Lowes_SellingStore – The Order Import plugin will populate this column with a Store Number indicating the Lowe’s store that originated the installed sale purchase order. If you don’t process such orders, you may or may not receive meaningful data at this time. Set the Data Type to String.

• LOWES_BOL_NUMBER – You must populate the Bill of Lading (BOL) number here. If it's empty, the Tracking Export plugin will skip it. If not, it will add a BOL to the export file. The complete label can only be printed if there’s a value here. Set the Data Type to String.

• (Optional) IsLowesOrderWithoutAssignedWarehouseID – The mappings in the Custom Company Setting Lowes_LocationWarehouse determine the Shipping Warehouse to set on the order based on the 850 EDI file. This column is set to True if an order doesn’t have a warehouse assigned, so you can filter and target such orders. Set the Data Type to Boolean. The default is False.

• (Optional) RETURNS_CODE – Set the Data Type to String.

• (*Optional) LOWES_BUSINESS_RULE_CODE – *Required if you print the invoice in Sellercloud with the PDF Invoice plugin. Set the Data Type to String.

• (*Optional) LOWES_SALESPERSON – *Required if you print the invoice in Sellercloud with the PDF Invoice plugin. Set the Data Type to String.

• (Optional) LOWES_CA_CUSTOMER_SERVICE_PHONE – Your customer service phone number on the RONA invoice. Set the Data Type to String.

• (Optional) LOWES_CA_CUSTOMER_SERVICE_EMAIL – Your customer service email address on the RONA invoice. Set the Data Type to String.

• LOWES_SALES_DIVISION – The sales division on the RONA invoice. Set the Data Type to String.

• (Optional) Lowes_ShippingRequiresPrepaid - Used by the Lowes Order Import 850 with 997 plugin. Checks if an order is Prepaid (PP) and marks the column as True. This ensures that when an order goes into Shipbridge, it will always be shipped using the correct third-party account. Set the Data Type to Boolean.

Order Import

The Lowes Order Import 850 with 997 plugin imports order data from Lowe’s to Sellercloud in EDI 850 format. If you set the optional Custom Company Setting Lowes_MatchByLowesSKUFirst to True, then Sellercloud will try to match Lowe’s ordered items’ IDs to the LOWES_SKU Custom Product Column in Sellercloud. If this fails, the plugin will match the default ProductID (SKU). Typically, the mappings in the Custom Company Setting Lowes_LocationWarehouse determine the Shipping Warehouse to set on the order based on the 850 EDI file. You can create the setting IsLowesOrderWithoutAssignedWarehouseID, and it will be automatically set to True if an order doesn’t have a warehouse assigned so you can filter and target such orders.

By default, orders will be imported with Third-Party Shipping required. To disable this, set the Custom Company Setting LOWES_ShippingRequiresThirdPartyBilling to False.

With the Lowes_SetSOSOrdersOnHold set to True, the plugin imports SOS (GS1-128) Orders and places them On Hold. If you set the Lowes_SetGenericNoteOnSOSOrders Custom Company Setting to True, it also sets an Order Note message to let you know that they are SOS orders. Sellercloud can only import such orders, so you must process them on Rithum.

Automate Order Import

To create a Scheduled Task that imports orders:

1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.

2. Click the green + icon: Create New Scheduled Task.

3. Complete as follows:

   1. Click Task Type and select Import Orders.
   2. Set the Task Name.
   3. Select the Company.
   4. Select the Start Time.
   5. Click CREATE.

4. On the Scheduled Task page, click the Edit button at the top right corner.

5. In the Details panel:

   1. Click Create Orders For Company and select the company designated for this integration.
   2. Click the Plugin menu and select Lowes Order Import 850 with 997.

6. In the Import Options panel:

   1. Set Import From to FTP and fill out the FTP fields with the details provided by Rithum.
   2. Set the FTP Directory to /outgoing/intchg.
   3. Make sure to check Use Passive and Use Secure FTP.

7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.

8. In the General panel:

   1. Fill in “FTP” in the Note field. This is a necessary requirement for the 997 transactions.
   2. Click the Enable button.

9. Click Save.

Order Acknowledgment

The Lowes Order Export EDI 855 plugin sends order acknowledgment to Lowe’s following the 855 EDI format and marks orders as acknowledged after export.

Order cancellations for this channel are not supported through the CommerceHub plugin. Instead, you can configure how order issues are handled using the following:

• If you set the Custom Company Setting RejectLowesUnknownSkus to True, when an order item is an Unknown SKU, you reject it with the reason bad_sku.

• If you set RejectLowesOutOfStockItems to True, and you don’t have an available quantity of an item, you reject the order and send a Rejection Reason "out_of_stock" or an Estimated Ship Date based on the EstimatedDaysToShipOutOfStockLowesOrders setting.

If an order has multiple items, and some items need to be accepted while others must be rejected for any reason, such as being out of stock, the plugin won’t export the order. Instead, it will create an order note and set the order to NotOkToProcess. The Client Setting Enable OKtoProcess Workflow is required for this functionality.

Automate Order Acknowledgment

To create a Scheduled Task that sends order acknowledgment:

1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.

2. Click the green + icon: Create New Scheduled Task.

3. Complete as follows:

   1. Click Task Type and select Export Orders.
   2. Set the Task Name.
   3. Select the Company.
   4. Select the Start Time.
   5. Click CREATE.

4. On the Scheduled Task page, click the Edit button at the top right corner.

5. In the Details panel:

   1. Click the User ID menu and select your email.
   2. Click the Saved Search menu and select the saved search you created earlier.
   3. Click the Export Via menu and select Lowes Order Export EDI 855.
   4. Check Mark Orders As Exported.
   5. Check This is Order Ack (Accept).

6. In the Export Options panel:

   1. Set Export To to FTP and fill out your FTP credentials.
   2. Set the Remote Folder path to /incoming/intchg.
   3. Make sure to check Use Passive and Use Secure FTP.

7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.

8. In the General panel, click the Enable toggle button.

9. Click Save.

Tracking Export

The Lowes Order Export EDI 856 plugin exports tracking from Sellercloud to Lowe’s following the 856 EDI format. The plugin supports SOS (GS1-128) Orders. However, these orders must go through the GS1-128 Label Plugin before the Lowes Order Export EDI 856 sends the tracking information.

All Split Orders must be shipped to send their tracking to Lowe’s.

Automate Tracking Export

To create a Scheduled Task that exports order tracking:

1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.

2. Click the green + icon: Create New Scheduled Task.

3. In the Details panel:

   1. Click the User ID menu and select your email.
   2. Click the Saved Search menu and select the saved search you created earlier.
   3. Click the Export Via menu and select Lowes Order Export EDI 856.
   4. Check This Is Tracking Export.

4. In the Export Options panel:

   1. Set Export To to FTP and fill out the FTP fields with the details provided by Rithum.
   2. Set the Remote Folder path to /incoming/intchg.
   3. Make sure to check Use Passive and Use Secure FTP.

5. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.

6. In the General panel, click the Enable toggle button.

7. Click Save.

Invoice Export

The Lowes Invoice Export EDI 810 plugin exports invoices from Sellercloud to Lowe’s in EDI 810 format.

All Split Orders must be shipped to send their invoice to Lowe’s.

Automate Invoice Export

To create a Scheduled Task that exports invoices:

1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.

2. Click the green + icon: Create New Scheduled Task.

3. In the Details panel:

   1. Click the User ID menu and select your email.
   2. Click the Saved Search menu and select the saved search you created earlier.
   3. Click the Export Via menu and select Lowes Invoice Export EDI 810.
   4. Check This Is Invoice Export.

4. In the Export Options panel:

   1. Set Export To to FTP and fill out the FTP fields with the details provided by Rithum.
   2. Set the Remote Folder path to /incoming/intchg.
   3. Make sure to check Use Passive and Use Secure FTP.

5. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.

6. In the General panel, click the Enable toggle button.

7. Click Save.

Inventory Export

The Lowes Inventory Export EDI 846 plugin exports inventory from Sellercloud to Lowe’s in EDI 846 format. It can either export all your available inventory or export per warehouse.

Automate Inventory Export

To create a Scheduled Task that exports inventory:

1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.

2. Click the green + icon: Create New Scheduled Task.

3. Complete as follows:

   1. Click Task Type and select Export Products.
   2. Set the Task Name.
   3. Select the Company.
   4. Select the Start Time.
   5. Click CREATE.

4. On the Scheduled Task page, click the Edit button at the top right corner.

5. In the Details panel:

   1. Click the User ID menu and select your email.
   2. Click the Saved Search menu and select the saved search you created earlier.
   3. Click the Export Via menu and select Lowes Inventory Export EDI 846.

6. In the Export Options panel:

   1. Set Export To to FTP and fill out the FTP fields with the details provided by Rithum.
   2. Set the Remote Folder path to /incoming/intchg.
   3. Make sure to check Use Passive and Use Secure FTP.

7. In the Frequency panel, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.

8. In the General panel, click the Enable toggle button.

9. Click Save.