Orgill is a distributor of hardware and home improvement products. Available in Flxpoint for automated inventory management and fulfillment.
How to Connect
Step 1: Log into your Flxpoint account and navigate to the Sources tab.
Step 2: Click on + Add Source (or Configure Single Source)
to begin creating a new source.
Step 3: Fill in your source details (e.g., vendor name, fulfillment preferences).
Once completed, click Save.
Step 4: After saving, navigate to
Get Inventory under Integrations in the left menu.
If you see "No integrations have been configured for this process yet",
click Start Creating Integrations.
Step 5: From the list of Custom Integrations or Standard Integrations,
locate and select Orgill. This will open the connection setup screen.
Step 6: In the New Orgill Connection form,
enter your Connection Name, FTP Protocol, FTP Host,
FTP Port, FTP User, and FTP Password.
Advanced Settings:
Advanced Settings:
Maintain Constant Connection – keeps an active FTP session throughout the process.
Use Unbuffered Private Data Channel – useful for secure FTPS connections
with “534 Policy requires SSL” errors.
Step 7: Click Test Connection to ensure your credentials
are valid. Once verified, click Save Connection.
Step 8: You’ll see the Configure Settings screen.
Provide your Inbound Remote File Folder and (if needed) Outbound Remote File Folder
to specify where Flxpoint will retrieve or place EDI files.
Next, enter:
Our Sender/Receiver Qualifier and Our Sender/Receiver ID
Their Sender/Receiver Qualifier and Their Sender/Receiver ID
These EDI qualifiers and IDs ensure files are exchanged correctly.
Click Save and Proceed when finished.
Step 9: Next, select or create your Mapping Template
under Define a Mapping Template. Map the necessary fields (e.g., SKU, Quantity)
to Flxpoint’s corresponding fields. Once mapped, click Save and Complete.
Step 10: Your Orgill integration for
Get Inventory is now active. Flxpoint will begin retrieving inventory
from your Orgill feed according to your scheduled settings.
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 (Primary)
What You Get:
The Orgill Get Inventory (Primary) tool connects to your Orgill FTP account and pulls in all the files you need to manage your inventory and product details. Here’s what it brings in:
All the Fields You Can Use:
Here’s the full list of data points you can pull in (labeled as "T" for text or "N" for numbers, just like in our dashboard):
Special Weight Options:
Ways to Customize:
With easy dropdowns and clickable options, you can:
Extra Goodies:
The Orgill Get Inventory (Primary) tool connects to your Orgill FTP account and pulls in all the files you need to manage your inventory and product details. Here’s what it brings in:
- WEB_INVENTORY.TXT: Shows stock levels for your chosen warehouses (e.g., Hurricane, UT; Sikeston, MO).
- Orgill-Compliance-Info.xlsx: Adds special details (like compliance info) to your products as custom fields if you opt for direct copy.
- WEB_DEPT.TXT & WEB_DEPT_SKU.TXT: Organizes products into three category levels (e.g., Hardware > Tools > Hammers).
- SKU_RESTRICTIONS.csv: Lists product limits (like shipping restrictions) for use in your setup.
- Orgill-Online-Attribute-File.xlsx: Imports images and details like ONLINE-TITLE-DESCRIPTION, ONLINE-LONG-DESCRIPTION, APPLICATION, WARRANTY, up to 10 feature bullets (ONLINE-FEATURE-BULLET-1 to 10, skipping 7), and document names (ITEM-DOCUMENT-NAME-1 to 3)—all ready for your product pages.
- Orgill-Standard-Data-File-DC-%s.xlsx: Pulls detailed stock info for each warehouse you select, counting products only once from the first file if they appear in multiple.
How It Connects:
We’ll set up a secure FTP connection with your Orgill account details (username, password, etc.). You can fine-tune it with:
- Folder Location: Point us to where your files live on the FTP server.
- Warehouse Choices: Pick which warehouses to track (e.g., Post Falls, ID; London, Ontario).
Your Customization Dashboard:
Our Mapping Dashboard—named "Orgill - Get Inventory [Primary]"—is your control center. It’s packed with dropdown menus, buttons (like "Save," "Duplicate," "Delete"), and options to shape Orgill’s data to fit your business perfectly.All the Fields You Can Use:
Here’s the full list of data points you can pull in (labeled as "T" for text or "N" for numbers, just like in our dashboard):
- ADV Cost (N): Advanced cost of the product.
- Application (T): What the product is used for.
- Benchmark Retail (N): A suggested retail price for comparison.
- Brand Name (T): The product’s brand.
- Buying Dept Desc (T): Description of the buying department.
- Category 1, 2, 3 (T): Three levels of product categories.
- Claims Code (T): Codes for product claims.
- Classification Code (T): Product classification info.
- Country Code (T): Where the product comes from.
- Cubic Divisor (N): Helps calculate shipping volume.
- Department Name (T): Name of the department.
- Division (T): Division the product belongs to.
- Factory Pack Size (N): How many items in a factory pack.
- Harmonized Code 1, 2, 3 (T): Customs codes for international shipping.
- Height, Length, Width (N): Product dimensions.
- Warehouse Quantities (N): Stock levels for each location, like:
- Item Document Name 1, 2, 3 (T): Names of attached documents.
- Min Purchase Multiple (N): Minimum order quantity.
- Model Number (T): Product model identifier.
- Nomenclature (T): Product naming details.
- Online Feature Bullet 1-10 (T): Up to 10 feature highlights (skips 7).
- Online Long Description (T): Detailed product description.
- Online Title Description (T): Short product title.
- Quantity Round Option (T): How quantities are rounded.
- Reg Cost (N): Regular cost of the product.
- Restrictions (T): Any product limits or rules.
- Retail Description (T): Description for retail display.
- Retail Sensitivity (T): Sensitivity level for retail.
- Retail Unit Of Measure (T): Unit used for retail (e.g., "each").
- Selected Warehouse Quantity (N): Total stock from your chosen warehouse.
- Selling Unit Of Measure (T): Unit for selling (e.g., "box").
- Selling Unit Pack Size (N): How many in a selling pack.
- Shelf Pack (N): Number of items per shelf pack.
- Shippable (T): Whether the product can be shipped.
- Suggested Retail (N): Recommended retail price.
- UPC Code (T): Universal product barcode.
- VP1 Cost, VP2 Cost (N): Vendor-specific costs.
- Velocity Code (T): How fast the product sells.
- Vendor Name, Number (T): Supplier details.
- Vendor Unit Of Measure (T): Vendor’s unit type.
- Warranty (T): Product warranty info.
- Weight (N): Product weight, with unit options below.
Special Weight Options:
- Weight Unit: Choose from "pound," "ounce," "gram," or "kilogram" in a dropdown.
(Tip: Pick this or the short version below—full name takes priority if both are set!)
- Weight Unit (Abbreviated): Short versions like "lb" or "oz" if you prefer.
Ways to Customize:
With easy dropdowns and clickable options, you can:
- Match It: Link an Orgill field (like UPC Code) to your field.
- Set It: Pick a fixed value (e.g., "pound" for all weights).
- Transform It: Use preset tools to tweak data (e.g., combine categories).
(Called "Mapping Set"—think of it as a quick fix kit.)
- Smart Rules: Add "if-then" logic (e.g., only map items with stock).
- Skip It: Select "Don’t Map" or "Set to Empty" to ignore a field.
Extra Goodies:
- 100 Custom Fields: Add your own special details, like "Seasonal Item."
- 10 Summary Fields: Get totals, like stock across all warehouses.
- Handy Buttons: "Save" your work, "Duplicate" setups, or "Delete" what you don’t need.
- Searchable Dropdowns: Type to find fields fast in long lists.
Get Inventory (Secondary)
What You Get:
The Orgill Get Inventory [Secondary] tool connects to your Orgill FTP account to keep your inventory fresh with the latest stock updates. It’s designed to work alongside the Primary process, focusing on specific warehouse data. Here’s what it pulls in:
All the Fields You Can Use:
These are the stock-related data points you can map (labeled "N" for numbers):
Ways to Customize:
With simple clicks and dropdowns, you can:
Extra Goodies:
The Orgill Get Inventory [Secondary] tool connects to your Orgill FTP account to keep your inventory fresh with the latest stock updates. It’s designed to work alongside the Primary process, focusing on specific warehouse data. Here’s what it pulls in:
- WEB_INVENTORY.TXT: The key file that gives us stock levels from your selected warehouses (e.g., Tifton, GA; Hurricane, UT).
How It Connects:
This tool uses the same secure FTP setup as the Primary integration (your username, password, and host details). You can customize it with these options:
- Folder Location: Set the FTP folder (e.g., `/orgillftp/webfiles/`) where the file lives.
- Warehouse Choices: Pick which warehouses to track, like:
- 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)
Tip: There’s an option to "Archive/Un-Archive Inventory" to manage out-of-stock items by setting quantities to zero, but we suggest skipping it if it’s already on for the Primary process to avoid confusion.
Your Customization Dashboard:
The Mapping Dashboard for "Orgill - Get Inventory [Secondary]" lets you shape the data to fit your needs with easy dropdowns, buttons (like "Save," "Duplicate," "Delete"), and a search bar. Here’s how you can use it:All the Fields You Can Use:
These are the stock-related data points you can map (labeled "N" for numbers):
- Hurricane, UT (US) Quantity (N): Stock from Hurricane, UT.
- Inwood, WV (US) Quantity (N): Stock from Inwood, WV.
- Kilgore, TX (US) Quantity (N): Stock from Kilgore, TX.
- London, Ontario (Canada) Quantity (N): Stock from London, Ontario.
- Post Falls, ID (US/Canada) Quantity (N): Stock from Post Falls, ID.
- Rome, NY (US) Quantity (N): Stock from Rome, NY.
- Sikeston, MO (US) Quantity (N): Stock from Sikeston, MO.
- Tifton, GA (US) Quantity (N): Stock from Tifton, GA.
- Selected Warehouse Quantity (N): Total stock from your chosen warehouse.
- SKU (T): Product identifier (text).
Ways to Customize:
With simple clicks and dropdowns, you can:
- Match It: Link a field (like Tifton, GA Quantity) to your inventory field.
- Set It: Pick a fixed value (e.g., zero for out-of-stock items).
- Transform It: Use preset tools to adjust data (e.g., combine quantities).
(We call this a "Mapping Set"—it’s like a quick tweak tool.)
- Smart Rules: Add "if-then" logic (e.g., map only if stock > 0).
- Skip It: Choose "Don’t Map" or "Set to Empty" to ignore a field.
Extra Goodies:
- 10 Custom Aggregate Fields: Combine data (e.g., total stock across warehouses).
- Handy Buttons: "Save" your setup, "Duplicate" it, or "Delete" if needed.
- Searchable Dropdowns: Type to find fields quickly.
Note: You can automate this process with a schedule, and you’ll get notifications when it runs (set to UTC time by default).
Order Operations
It submits orders to vendors for fulfillment and subsequently imports the shipment details, ensuring an integration between order processing and shipment tracking.
Send Fulfillment Requests
What You Get:
The Orgill integration helps you send fulfillment requests smoothly by connecting to your Orgill FTP account. It prepares and sends your orders directly to Orgill for processing. Here’s what it includes:
Send Fulfillment Requests Mappings:
These fields map your order data to Orgill’s required fields (enabled mappings are active):
Extra Features:
The Orgill integration helps you send fulfillment requests smoothly by connecting to your Orgill FTP account. It prepares and sends your orders directly to Orgill for processing. Here’s what it includes:
- Send Fulfillment Requests: Creates and sends purchase orders to Orgill for fulfillment.
How It Connects:
This tool uses your secure FTP credentials to send 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 your fulfillment requests are handled with these options:
- Outbound Remote File Folder: Where the fulfillment files are sent (e.g., `/UP/`).
- Inbound Remote File Folder: Where response files are received (e.g., `/X12ASH856/`).
- Our Sender/Receiver Qualifier: Your identifier type (e.g., "ZZ").
- Our Sender/Receiver ID: Your unique ID (e.g., "KTM").
- Their Sender/Receiver Qualifier: Orgill’s identifier type (e.g., "ORGILL").
- Their Sender/Receiver ID: Orgill’s unique ID (e.g., "ZZ").
- Account Number: Your Orgill account number for authentication.
- Purchase Order Type: Choose the order type, such as:
DS - Dropship
NE - New Order
- Hold for X Hours: Option to delay sending requests (if needed).
- Send During Business Hours: Option to send requests only during business hours.
Your Customization Dashboard:
The dashboard lets you map your order data to Orgill’s fields with easy controls. Here’s what you can set up:Send Fulfillment Requests Mappings:
These fields map your order data to Orgill’s required fields (enabled mappings are active):
- Quantity: Maps to Fulfillment Request Item : Quantity (Enabled)
- Unit Price: Maps to Fulfillment Request Item : Cost (Enabled)
- Vendor’s Item Number (VN): Maps to Fulfillment Request Item : SKU (Enabled)
- Buyer’s Catalog Number (CB): Not mapped by default (Disabled)
- Buyer’s Item Number (IN): Not mapped by default (Disabled)
- Buyer’s Part Number (BP): Not mapped by default (Disabled)
- Company Part Number (PN): Not mapped by default (Disabled)
- Purchaser’s Item Code (PI): Not mapped by default (Disabled)
- Stock Keeping Unit (SKU): Not mapped by default (Disabled)
- UPC Consumer Package Code (UP): Not mapped by default (Disabled)
- Unit Measurement Code: Not mapped by default (Disabled)
- Vendor’s Catalog Number (VC): Not mapped by default (Disabled)
- Vendor’s Part Number (VP): Not mapped by default (Disabled)
Note: You can enable or disable mappings to match your needs. Required fields will be marked clearly in the dashboard.
Extra Features:
- Use simple switches to turn mappings on or off as needed.
- Save, duplicate, or delete your mapping templates with easy buttons.