Orgill is a major wholesale distributor of hardware, home improvement, and building supplies, serving independent retailers, hardware stores, and contractors. They offer a vast selection of tools, plumbing, electrical, and outdoor products with nationwide distribution.
How to Connect
Step 1: Orgill is not currently supported by default.
Step 2: If you see Orgill in the FLX Supplier Directory, click Request Integration to proceed.
Step 3: Provide details about your Orgill account, order volume, and any special requirements for home improvement items.
Step 4: Submit the form, and our team will respond regarding Orgill support status.
Product Operations
The primary operation handles the bulk of your inventory management needs, while the secondary operation allows for more detailed control, such as focusing on specific products or updates
Get Inventory and Pricing & Quantity
What You Get:
The Orgill integration keeps your inventory and pricing up to date by connecting to your Orgill FTP account. It pulls in the latest stock levels and pricing details to streamline your product management. Here’s what it includes:
Get Inventory Mappings:
These fields are pulled from the `WEB_INVENTORY.TXT` file and can be mapped as follows (all currently enabled unless noted):
Pricing & Quantity Mappings:
These fields sync pricing and quantity data from Orgill to your products (all currently enabled):
Extra Features:
The Orgill integration keeps your inventory and pricing up to date by connecting to your Orgill FTP account. It pulls in the latest stock levels and pricing details to streamline your product management. Here’s what it includes:
- Get Inventory: Fetches stock data from the `WEB_INVENTORY.TXT` file on your FTP.
- Pricing & Quantity: Updates pricing and stock quantities for your products.
How It Connects:
This tool uses your secure FTP credentials to access the data. You’ll need to set up the following:
- FTP Username & Password: Your login details for the Orgill FTP.
- FTP Port & Host: Connection settings (e.g., port number and server address).
Default Settings:
Customize how the data is handled with these options:
- Inbound Remote File Folder: Where the files are located (e.g., `/orgillftp/webfiles/`).
- Select Warehouse: Choose one warehouse to track your stock from, such as:
Tifton, GA (US)
Rome, NY (US)
Inwood, WV (US)
Hurricane, UT (US)
Kilgore, TX (US)
Sikeston, MO (US)
London, Ontario (Canada)
Post Falls, ID (US/Canada)
- Our Sender/Receiver ID & Qualifier: Your identifiers for data exchange.
- Their Sender/Receiver ID & Qualifier: Orgill’s identifiers (e.g., "ORGILL").
Your Customization Dashboard:
The dashboard lets you map Orgill data to your product fields with simple controls. Here’s what you can set up:Get Inventory Mappings:
These fields are pulled from the `WEB_INVENTORY.TXT` file and can be mapped as follows (all currently enabled unless noted):
- All Attributes: Maps to Inventory Parent : All Attributes (Enabled)
- All Custom Fields: Maps to Inventory Variant : All Custom Fields (Enabled)
- All Images: Maps to Inventory Parent : All Images (Enabled)
- All Images: Maps to Inventory Variant : All Images (Enabled)
- Brand Name: Maps to Inventory Parent : Brand (Enabled)
- Category 1: Maps to Inventory Parent : Category 1 (Enabled)
- Category 2: Maps to Inventory Parent : Category 2 (Enabled)
- Category 3: Maps to Inventory Parent : Category 3 (Enabled)
- Reg Cost: Maps to Inventory Variant : Cost (Enabled)
- Custom Field 1 Name: Maps to Inventory Variant : Custom Field 1 Name (Enabled)
- Application: Maps to Inventory Variant : Custom Field 1 Value (Enabled)
- Custom Field 10 Name: Maps to Inventory Variant : Custom Field 10 Name (Enabled)
- Harmonized Code 1: Maps to Inventory Variant : Custom Field 10 Value (Enabled)
- Custom Field 11 Name: Maps to Inventory Variant : Custom Field 11 Name (Enabled)
- Harmonized Code 2: Maps to Inventory Variant : Custom Field 11 Value (Enabled)
- Custom Field 12 Name: Maps to Inventory Variant : Custom Field 12 Name (Enabled)
- Harmonized Code 3: Maps to Inventory Variant : Custom Field 12 Value (Enabled)
- Custom Field 13 Name: Maps to Inventory Variant : Custom Field 13 Name (Enabled)
- Item Document Name 1: Maps to Inventory Variant : Custom Field 13 Value (Enabled)
- Custom Field 2 Name: Maps to Inventory Variant : Custom Field 2 Name (Enabled)
- Item Document Name 2: Maps to Inventory Variant : Custom Field 2 Value (Enabled)
- Custom Field 3 Name: Maps to Inventory Variant : Custom Field 3 Name (Enabled)
- Item Document Name 3: Maps to Inventory Variant : Custom Field 3 Value (Enabled)
- Custom Field 4 Name: Maps to Inventory Variant : Custom Field 4 Name (Enabled)
- Item Document Name 4: Maps to Inventory Variant : Custom Field 4 Value (Enabled)
- Custom Field 5 Name: Maps to Inventory Variant : Custom Field 5 Name (Enabled)
- Item Document Name 5: Maps to Inventory Variant : Custom Field 5 Value (Enabled)
- Custom Field 6 Name: Maps to Inventory Variant : Custom Field 6 Name (Enabled)
- Item Document Name 6: Maps to Inventory Variant : Custom Field 6 Value (Enabled)
- Custom Field 7 Name: Maps to Inventory Variant : Custom Field 7 Name (Enabled)
- Item Document Name 7: Maps to Inventory Variant : Custom Field 7 Value (Enabled)
- Custom Field 8 Name: Maps to Inventory Variant : Custom Field 8 Name (Enabled)
- Item Document Name 8: Maps to Inventory Variant : Custom Field 8 Value (Enabled)
- Custom Field 9 Name: Maps to Inventory Variant : Custom Field 9 Name (Enabled)
- Factory Pack Size: Maps to Inventory Variant : Custom Field 9 Value (Enabled)
- Online Long Description: Maps to Inventory Parent : Description (Enabled)
- Retail Description: Maps to Inventory Variant : Description (Enabled)
- Dimension Unit: Maps to Inventory Variant : Dimension Unit (Enabled)
- Height: Maps to Inventory Variant : Height (Enabled)
- Length: Maps to Inventory Variant : Length (Enabled)
- Model Number: Maps to Inventory Variant : MPN (Enabled)
- Suggested Retail: Maps to Inventory Variant : MSRP (Enabled)
- Selected Warehouse Quantity: Maps to Inventory Variant : Quantity (Enabled)
- Online Title Description: Maps to Inventory Variant : Title (Enabled)
- Online Title Description: Maps to Inventory Parent : Title (Enabled)
- UPC Code: Maps to Inventory Variant : UPC (Enabled)
- Weight: Maps to Inventory Variant : Weight (Enabled)
- Weight Unit: Maps to Inventory Variant : Weight Unit (Enabled)
- Width: Maps to Inventory Variant : Width (Enabled)
- SKU: Maps to Inventory Variant : SKU (Required, cannot be disabled)
- SKU: Maps to Inventory Parent : Parent SKU (Required, cannot be disabled)
- SKU: Maps to Inventory Variant : Master SKU (Required, cannot be disabled)
Pricing & Quantity Mappings:
These fields sync pricing and quantity data from Orgill to your products (all currently enabled):
- Selected Warehouse Quantity: Maps to Inventory Variant : Quantity (Enabled)
- SKU: Maps to Inventory Variant : SKU (Required, cannot be disabled)
Note: Some fields (like SKU) are required and cannot be turned off. You can enable or disable other mappings as needed to fit your setup.
Extra Features:
- Set a SKU prefix to customize product identifiers.
- Choose to enable or require mappings with simple switches.
Order Operations
The primary operation handles the bulk of your inventory management needs, while the secondary operation allows for more detailed control, such as focusing on specific products or updates
Send Orders
What You Get:
The Orgill integration makes sending orders effortless by connecting to your Orgill FTP account. It automates the process of creating and sending purchase orders to Orgill for fulfillment. Here’s what it includes:
Send Orders Mappings:
These fields map your order data to Orgill’s required fields (enabled mappings are active):
Extra Features:
The Orgill integration makes sending orders effortless by connecting to your Orgill FTP account. It automates the process of creating and sending purchase orders to Orgill for fulfillment. Here’s what it includes:
- Send Orders: Prepares and sends your purchase orders directly to Orgill.
How It Connects:
This tool uses a secure FTP connection to send your orders. Orgill requires a separate FTP connection for the Send Orders operation, even if you’re using the same connection as other operations like Get Shipments. You’ll need to set up the following:
- FTP User: Your FTP username (e.g., "qwar").
- FTP Password: Your FTP password (e.g., "qraw").
- FTP Port: The port number for the connection (e.g., "qwreqwr").
- FTP Host: The server address (e.g., "asdaqs").
- FTP Protocol: Choose the protocol, such as FTP.
Note: You can choose to use the same FTP connection as the Get Shipments operation if the credentials are the same.
Default Settings:
Customize how your orders are sent with these options:
- Automatically Send Orders: Option to enable automatic sending of orders.
- Inbound Remote File Folder: Where response files are received (e.g., `/X12ASH856/`).
- Outbound Remote File Folder: Where order files are sent (e.g., `/UP/`).
- Purchase Order Type: Specify the order type (e.g., "DS-Dropship").
- Account Number: Your Orgill account number (e.g., "zxwvvas").
- Their Sender/Receiver ID: Orgill’s unique ID (e.g., "ZZ").
- Their Sender/Receiver Qualifier: Orgill’s identifier type (e.g., "ORGILL").
- Our Sender/Receiver ID: Your unique ID (e.g., "KTM").
- Our Sender/Receiver Qualifier: Your identifier type (e.g., "ZZ").
- Use Unbuffered Private Data Channel: Option to try and resolve FTP connections that fail with a "534 Policy requires SSL" error.
- Maintain Constant Connection: Option to keep a constant connection throughout the integration for smoother file transfers.
Your Customization Dashboard:
The dashboard lets you map your order data to Orgill’s fields with simple controls. Here’s what you can set up:Send Orders Mappings:
These fields map your order data to Orgill’s required fields (enabled mappings are active):
- Cost: Maps to Orgill Order Item : Unit Price (Enabled)
- Quantity: Maps to Orgill Order Item : Quantity (Enabled)
- SKU: Maps to Orgill Order Item : Vendor’s Item Number (VN) (Enabled)
- Unit Measurement Code: Maps to Orgill Order Item : Unit Measurement Code (Enabled)
Note: You can enable or disable mappings as needed to fit your setup.
Extra Features:
- Automatically send orders with a single toggle.
- Use simple switches to enable or disable mappings.