The Keystone Integration allows you to connect your store with Keystone’s inventory, pricing, and order fulfillment services. This guide walks you through the available configuration options and required credentials to set up the integration.
Credentials
To connect to Keystone, you need the following credentials:
-
FTP Username – Used to access Keystone’s FTP server for inventory and product data.
-
FTP Password – The password associated with your FTP account.
-
Account ID – Your unique identifier for Keystone’s services. Ensure you only use the numeric portion of your Account ID.
-
Development API Key – Used for testing and development purposes.
-
Production API Key – The key required for live API calls when processing real data.
-
Environment – Determines whether the integration runs in "production" mode or a testing environment.
Options
The integration includes several configurable options to optimize how data is processed.
Enable API Inventory (Faster)
This option enables real-time inventory checks via API instead of relying on batch file updates. Enabling this may improve accuracy and speed when checking stock levels.
Country for Inventory
Determines which country’s inventory stock levels are used for availability calculations. For Canadian inventory, stock is aggregated across Keystone’s Canadian warehouses.
Use MAP Pricing from Inventory File
When enabled, the integration pulls Minimum Advertised Pricing (MAP) from Keystone’s data feed. If you need to adjust or remove MAP pricing, visit the Maintenance tab.
Enable Case Packed Products
When enabled, the integration will recognize case-packed products. This means certain items may only be available in specified quantities rather than individually.
If this option is not enabled, you may see an error message like the following:
DEBUG [Keystone] Setting SKU W31912 stock to 0: case packed products is disabled and case quantity is 10.
This means that since case-packed products are disabled, the stock will not be updated correctly unless the option is enabled.
Disable Keystone Shipping Cost for Cost Calculations
By default, Keystone’s provided shipping cost is used in cost calculations. If disabled, a custom shipping cost can be applied using settings in the Advanced tab.
Shipping Cost Flat Rate
This field allows you to set a flat shipping cost for Keystone orders. This cost is combined with UPS Ground Accessorials (if the item is UPS-shippable). If the item requires freight shipping (US-LTL), Keystone’s rate is used instead.
Send Orders Using Spark Shipping Order ID
When enabled, orders sent to Keystone will use the Spark Shipping Order ID instead of an internal reference number.
Troubleshooting
-
Incorrect inventory levels? Ensure API inventory is enabled and that the correct country is selected.
-
Shipping costs seem incorrect? Check whether Keystone’s shipping cost is enabled or if a custom rate is overriding it.
-
Orders not being accepted? Double-check API credentials, especially the Production API Key.
For further assistance, please reach out to our support team.