Sell on Lowe's

Updated 1 day ago

This topic is about integrating your SellerCloud account with Lowes.com. For instructions on integrating with Lowe's ATGStores.com, see these Lowe's (ATG) instructions.

Prerequisite: This feature requires selecting the Client Setting Enable Custom Company Settings. The custom settings will store company-level information for use by the plugins and channel integrations. 


Integration workflow

Lowe's has its own EDI integration through CommerceHub, who will provide instructions and an FTP or VAN for testing and production.

The integration workflow comprises the following components:

  1. Seller: Create a separate company for Lowe's, and then create the required custom company settings.
  2. SellerCloud Support: Create the required custom order and product columns.
  3. SellerCloud Support: Install the Lowe's plugins on the server.
  4. Seller: Create saved searches and scheduled tasks for the installed plugins.

Creating the custom company settings

To create the custom company settings required by the plugins, open your Lowe's company's Toolbox > Custom Settings > create the settings listed below:  

  • Lowes_ISAID
  • Lowes_CustomerISAID (typically the client's phone number)
  • Lowes_CustomerQualifier
  • Lowes_Qualifier
  • GS1_CompanyPrefix
  • ISAControlNumber*
  • GSControlNumber*
  • STControlNumber*

* ISAControlNumber, GSControlNumber, and STControlNumber can all start at 1. The tracking and inventory exports will increment this number accordingly. 


Creating the custom columns

SellerCloud Support will create the following settings for your Lowe's company:


Installing the plugins

A plugin contains instructions on how to create an import or export file. For example, instead of just mapping an order of columns for an export file, a plugin lets you to do more complex tasks than having one row per line item or one row per product. You can also manipulate values that are exported, allowing the file to conform to any standard.

SellerCloud Support will install the following Lowe's plugins onto the server. Note: The table below also describes the type of saved search that the seller will create for the plugins' scheduled tasks.

PLUGIN

INSTRUCTIONS

Lowes Inventory Export EDI 846

DESCRIPTION

  • Lowe's SKU is required on the 846, and is pulled from the custom product column LOWES_SKU
  • This can export all the inventory available or per warehouse:
    • To export per warehouse, set up the Channel Warehouse Mapping page. This works for all channels set on the company and exports only those with values to the Channel Warehouse code. A safety quantity can also be set up.

SAVED SEARCH

  1. Create an Inventory Saved Search.
  2. Choose any filters you want to choose which products to send.
Lowes Order Import 850 with 997

DESCRIPTION

  • Ship To Store orders will be marked as such in the custom order column IsShipToStore

  • This plugin pulls order files from the FTP (or VAN); creates the orders in SellerCloud; and returns a 997 acknowledgment for each file sent. The 997 will be placed on the server as defined in the scheduled task.
    • For FTP, the scheduled task's Queued Job Note must be set to "FTP" so the plugin will know to drop the file in the "/incoming/intchg/" folder, as compared to a VAN, where the file is dropped in the root directory.
When using FTP with CommerceHub, all documents for all CommerceHub integrations will be sent to the same FTP directory. Thus, if you are using FTP instead of VAN, the setting to “Delete files after processing” on the task should be set to FALSE, as to not delete the files from other integrations. To alert the plugin that the Lowe's order files must be deleted after processing, the scheduled task's Queued Job Note should be set to "FTP."
Tracking Export (856) - Lowes Order Export EDI 856

SAVED SEARCH AND SCHEDULED TASK

  1. Create an Orders Saved Search.
  2. Filter as follows:
  • Company = Your Lowe's company
  • Status = InProcess or Completed
  • Shipping Status = Fully Shipped
  • Tracking Uploaded = Not Uploaded
  1. On the 856 scheduled task, check the setting This is Tracking Export.
Order Export (855) - Lowes Order Export EDI 855

DESCRIPTION

  • Marks orders as OrderAcknowedgeForAcceptToChannel accepts all orders.
  • Requires these custom company settings for the default company:
    • RejectLowesUnknownSkus - If set to true: If the item comes in with an unknown SKU, it will be rejected with the reason "bad_sku"

    • RejectLowesOutOfStockItems - If set to true: If the item does not have quantity available, reject it and either enter any reject reason (can be "out_of_stock") or an estimated ship date (see next point).

    • EstimatedDaysToShipOutOfStockLowesOrders -
      • If this setting exists and has a valid value: Send an estimated ship date of the order date plus x number of days from this setting.

      • If this setting does not exist or has no valid value: Do not send an estimated ship date and instead send a reject reason "out_of_stock." The plugin should still work if one or more of these settings do not exist.

      • If the order has multiple items, and some items must be accepted and some must be rejected (for any reason), then DO NOT EXPORT THE ORDER. Instead, create an explanatory order note and set the order to NotOkToProcess.

SAVED SEARCH AND SCHEDULED TASK

  1. Create an Orders Saved Search.
  2. Filter as follows:
  • Company = Your Lowe's company
  • Status = InProcess or Completed
  • Order Ack (Accept) = No
  1. On the 855 scheduled task, check the setting This is Order Ack (Accept).
Lowes Invoice Export EDI 810

SAVED SEARCH AND SCHEDULED TASK

  1. Create an Orders Saved Search.
  2. Filter as follows:
  • Company = Your Lowe's company
  • Status = InProcess or Completed
  • Shipping Status = Fully Shipped
  • Tracking Uploaded = Uploaded
  • Invoice Sent = Not Sent
  1. On the 810 scheduled task, check the setting This is Invoice Export. 
Lowes Packing Slip PDF

Creating saved searches and scheduled tasks

Each of the plugins requires the setup of a scheduled task, which Let you configure certain action for automatic recurrence at specific intervals. Each of the scheduled tasks will use saved searches (see the plugins table above for each required search).

For example, a scheduled task for the Lowe's Tracking Export would use a Lowe's Tracking saved search. Show me where.

Learn how to create a tracking export scheduled task.


How did we do?


Explore our brands and social media
Skustack Memaila Turnstock WayToPay.Me Facebook Instagram Linkedin YouToube Twitter