Lowes Account Integration

Overview

Lowe’s Home Improvement is one of the leading home improvement retailers, catering both to do-it-yourself homeowners and professional contractors. They sell a wide range of products for various areas of the home, including appliances, tools, hardware, electrical and plumbing supplies, lumber, building materials, and outdoor living essentials. 

Integrating Lowe’s allows you to sell on their platform from Sellercloud. This integration works through EDI documents transmitting information between the two services. The document exchange goes through CommerceHub – a third-party platform that provides the Secure File Transfer Protocol (SFTP) server and credentials.

The following plugins are currently available for Sellercloud:

• Order Import – Imports orders from Lowe’s to Sellercloud in EDI 850 format.
• Order Acknowledgement – Sends order acknowledgment to Lowe’s in EDI 855 format.
• Tracking Export  – Exports tracking information to Lowe’s in EDI 856 format.
• Invoice Export – Exports invoices to Lowe’s in EDI 810 format.
• PDF Invoice – Creates printable PDF packing slips.
• Inventory Export – Exports inventory to Lowe’s in EDI 846 format.

If necessary, you can contact Sellercloud Support to request additional customizations or other plugins for this integration.

---

Prerequisites

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

Contact CommerceHub for your SFTP details: Server Name, Username, and Password. You will need them when setting up the scheduled tasks to automate the plugins. Additionally, make sure to ask for their ISA ID – you will it when populating the custom company settings.

Custom Company Settings

Create the following Custom Company Settings.

On your default company:

• STControlNumber
• GSControlNumber
• ISAControlNumber

On the company created for the integration:

• Lowes_CustomerISAID – Enter a phone number that is not used for any other EDI integration.
• Lowes_ISAID – Contact Lowe’s for the value of this column. Usually, it’s 7047581000CH.
• Lowes_CustomerQualifier – Set to ZZ.
• Lowes_Qualifier – Set to 12.
• Lowes_VendorIDForSSCC – A 6-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 or an estimated ship date based on the EstimatedDaysToShipOutOfStockLowesOrders setting. 
• EstimatedDaysToShipOutOfStockLowesOrders – When this setting exists and has a valid value, you send an estimated ship date based on the date of 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.
• Lowes_SetSOSOrdersOnHold – Optional, defaults to False. Set to True to set SOS orders on hold.
• Lowes_SetGenericNoteOnSOSOrders – Optional, defaults to False. Set to True to add this note to SOS orders: ‘Order is SOS, order import plugin set it ON HOLD.’
• Lowes_UNSP_ShippingService – Optional. Enter the shipping service code that needs to be assigned to orders with code UNSP. Example value: FEDX_CG or UPSN_CG.
• Lowes_Lock_UNSP_ShippingService – Optional. Set to True to lock the service code from the Lowes_UNSP_ShippingService column.
• LOWES_ShippingRequiresThirdPartyBilling – Optional but defaults to True if you don’t create it. When True, orders will be imported with Third-Party Shipping required.
• Lowes_MatchByLowesSKUFirst – Optional. Defaults to False if you don’t create it. 
• Lowes_SetCustomerServiceStatusOnOrderToRequiresAttention – Optional. Defaults to False if you don’t create it. When True, sets the customer service status on SOS orders to Requires_Attention.
• 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.
• Lowes_ReferenceIdentificationQualifier – Optional. If you add it and set it to lowesca, the N1 segment 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 Tax Registration IDs.
• Lowes_TaxRegistrationID – Optional only if the Lowes_ReferenceIdentificationQualifier setting is missing or different than lowesca. Otherwise, it is required, and it has to contain the Tax Registration ID. If more than one ID has to be reported, must be semi-column delimited – ’22 AAAAA0000A 1Z5; 9999999999 TQ 001′.
• Lowes_NetTermDays – Optional. The number of days until the total invoice amount is due. The default value is 30.
• Lowes_InboundToParty – The value of the Reference Identification segment in the product export EDI 846, used to associate additional identifying information with an item record.
• Lowes_Expected_Qty – If there’s no quantity on hand, this setting is exported as the quantity expected to become available by the date/time of the product custom column EXPECTED_AVAILABLE_DATE. Defaults to 1.
• ExportMultipleWarehousesOnLowes846 – True or False. When True, the mapping from Lowes_WarehouseCodeMapping will be used to send quantities per warehouse.
• Lowes_WarehouseCodeMapping – Used to map warehouses to 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”

Sellercloud Support

You must contact Sellercloud Support and request:

1. To install the Lowe’s Plugins on your server.
2. The following Custom Product and Order Columns:

Custom Product Columns

• • Lowes_Enabled – Optional column used to enable only specific products for Lowe’s. Set to True for any products you want to send with the Inventory Export plugin.
  • LOWES_SKU – A product’s SKU at Lowe’s.
  • LowesSafetyQty – Required column – a Safety Quantity for products at Lowe’s. To use this setting to set the Safety Quantity on the product level, you must set the {SafetyQty} in the Lowes_WarehouseCodeMapping setting to 0.
  • EXPECTED_AVAILABLE_DATE – If the value is missing, two months will be added to the current date.
  • LOWES_VENDOR_SKU – Empty by default. If you populate it, it will be used as the product identifier in the product export’s line item information segment, and Sellercloud will send it as the Vendor SKU.

Custom Order Columns

• Lowes_StoreNumber – String.
• ProcessedForSSCCID – Defaults to False. Gets set to True on Non-SOS orders and SOS orders processed by the GS1-128 Label plugin.
• LOWES_BOL_NUMBER – String. 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.
• IS_SOS_ORDER – Boolean, defaults to False. Shows if an order is an SOS order.
• IsShipToStore – Optional Boolean. Shows if an order is ship-to-store.
• RETURNS_CODE – Optional String.
• LOWES_BUSINESS_RULE_CODE – Optional String. It is only required if you are printing the invoice in Sellercloud with the Order PDF Invoice plugin.
• LOWES_SALESPERSON – Optional String. It is only required if you are printing the invoice in Sellercloud with the Order PDF Invoice plugin.
• LOWES_CA_CUSTOMER_SERVICE_PHONE – Optional String, used for the Lowe’s Canada invoice.
• LOWES_CA_CUSTOMER_SERVICE_EMAIL – Optional String, used for the Lowe’s Canada invoice.

---

Order Import

This plugin imports order data from Lowe’s to Sellercloud in EDI 850 format.

If you set the optional custom 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 Sellercloud SKU.

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 – you still need to process them on CommerceHub.

Automate Order Import

To create a Scheduled Task that regularly 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. The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
5. Click the Edit button on the top right.
6. In the Details section:
   1. Click the Create Orders For Company menu and select the company you designated for this integration.
   2. Click the Plugin menu and select Lowes Order Import 850 with 997.
7. In the Import Options section, set Import From to FTP and fill out the FTP fields. Make sure to check Use Passive and Use Secure FTP.
8. In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
9. In the General section, click the Enable button. Type “FTP” in the Note field to place the 997 files in a specific folder on the FTP.
10. Click Save on the top right.

---

Order Acknowledgment

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

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, then 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.

Before you move on, create a Saved Search for orders filtered by:

• Company – The company you created for the integration
• Order Split Type – Parent Split Order for the first task, Not a Parent or Child for the second task.
• Order Status – InProcess Or Completed
• Payment Status – Charged
• Shipping Status – Unshipped
• Invoice Uploaded – No
• Exported – Not Exported
• Order Ack (Accept) – No

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. The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
5. Click the Edit button on the top right.
6. In the Details section:
   1. Click the User ID menu and select your ID.
   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).
7. In the Export Options section, set Export To to FTP and fill out the FTP fields. Make sure to check Use Passive and Use Secure FTP.
8. In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
9. In the General section, click the Enable toggle button.
10. Click Save on the top right.

---

Tracking Export

This plugin exports tracking from Sellercloud to Lowe’s following the 856 EDI format.

The plugin supports SOS (GS1-128) orders. SOS orders must go through the GS1-128 Label Plugin before sending the tracking information. 

Before you move on, create a Saved Search for orders filtered by:

• Company – The company you created for the integration
• Order Split Type – Parent Split Order for the first task, Not a Parent or Child for the second task.
• ProcessedForSSCCID – True
• Order Status – InProcess Or Completed
• Shipping Status – FullyShipped
• Payment Status – Charged
• Tracking Uploaded – No
• Order Ack (Accept) – Yes

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. 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. The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
5. Click the Edit button on the top right.
6. In the Details section:
   1. Click the User ID menu and select your ID.
   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.
7. In the Export Options section, set Export To to FTP and fill out the FTP fields. Make sure to check Use Passive and Use Secure FTP.
8. In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
9. In the General section, click the Enable toggle button.
10. Click Save on the top right.

---

Invoice Export

This plugin exports invoices from Sellercloud to Lowe’s in EDI 810 format.

Before you move on, create a Saved Search for orders filtered by:

• Company – The company you created for the integration
• Order Split Type – Parent Split Order for the first task, Not a Parent or Child for the second task.
• Shipping Status – Fully Shipped
• Order Status – InProcess Or Completed
• Invoice Uploaded – No
• Tracking Uploaded – Yes

Automate Invoice Export

To create a Scheduled Task that regularly exports invoices:

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. The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
5. Click the Edit button on the top right.
6. In the Details section:
   1. Click the User ID menu and select your ID.
   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.
7. In the Export Options section, set Export To to FTP and fill out the FTP fields. Make sure to check Use Secure FTP.
8. In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
9. In the General section, click the Enable toggle button.
10. Click Save on the top right.

---

Order PDF Invoice

This plugin lets you create and print packing slips with information about your orders and the products they include. This plugin doesn’t require a scheduled task.

To set up the invoice plugin:

1. Go to the Company Settings of the company you created for the integration
2. Click Toolbox and select Invoice Settings.
3. Click Per Channel Preferences.
4. For Website, select Plugin > Lowes Packing Slip PDF.
5. Click Save.

---

Inventory Export

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

Optionally, you can enable only specific products for Lowe’s by setting their Lowes_Enabled Custom Column for Products to True:

• For one product at a time: go to the Product Details Page > click Toolbox and select Custom Columns > click Edit, update the Lowes_Enabled column, and Save.
• For multiple products in bulk: follow the steps to Bulk Update Products and use the Lowes_Enabled column – set it to True for all products you want to enable.

Unlike core integrations, plugin integrations don’t require products to be in the company with the scheduled tasks. The export will include the products you select with your Saved Search.

Next, create a Saved Search for products filtered by Lowes_Enabled – True. Optionally, you can add more filters to the search.

Automate Inventory Export

To create a Scheduled Task that regularly 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. The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
5. Click the Edit button on the top right.
6. In the Details section:
   1. Click the User ID menu and select your ID.
   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.
7. In the Export Options section, set Export To to FTP and fill out the FTP fields. Make sure to check Use Passive and Use Secure FTP.
8. In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
9. In the General section, click the Enable toggle button.
10. Click Save on the top right.

---

SOS (GS1-128) Orders Workflow

Apart from the items in stock in Lowe’s stores, there are lots more available through Special Order. Sellercloud supports Special Order Sales (SOS) and generates GS1-128 labels for them.

GS1-128 is a widely used barcode symbology that encodes data according to the GS1 System – a global standard for identifying and capturing information about products, assets, and locations in the supply chain. GS1-128 allows the inclusion of various information, such as product ID, batch, or lot numbers, expiration dates, and other relevant data.

This is the SOS workflow:

1. The Order Import plugin imports orders.
   1. If an order is an SOS order, the IS_SOS_ORDER column gets set to True, and the ProcessedForSSCCID column gets set to False.
   2. If an order is NOT an SOS order, the IS_SOS_ORDER column gets set to False, and the ProcessedForSSCCID column gets set to True. 
2. The Tracking Export plugin initially excludes the SOS orders whose ProcessedForSSCCID value has been set to False by the Order Import plugin.
3. You ship your SOS orders through Shipbridge or another medium.
4. After you ship them, use the GS1-128 Label plugin, and it:
   1. Generates the SSCC ID on the package.
   2. Sets ProcessedForSSCCID to True.
   3. Exports a GS1-128 PDF label for each package.
5. Now that the ProcessedForSSCCID is set to True by the GS1-128 Label plugin, the Tracking Export plugin’s saved search targets the SOS orders, so it grabs and sends the right information.

---