TABLE OF CONTENTS
- Introduction
- Drop Shipping Modes
- Keystone SKU Import
- Keystone Inventory Update
- Keystone Inventory Update Full
- Keystone Inventory Update FTPS
- Keystone Orders Drop Shipping
- Keystone Orders Tracking Import
- Keystone Catalog Import
- Keystone Cost Import
Introduction
Are you looking to automate Keystone Automotive Operations catalog import, pricing, and inventory/stock updates and dropshipping when listing products to eBay, Shopify, Amazon, Walmart.com, BigCommerce and other e-commerce marketplaces and channels?
The Keystone connection is comprised of multiple separate automations, each performing a function.
You should enable them in this order. Read the description for each section to understand why.
- Keystone SKU Import or Catalog Import
- Keystone Inventory Update Full
- Keystone Inventory Update
- Keystone Orders Drop Shipping
- Keystone Orders Tracking Import
Then optionally, you may enable the remaining integrations should you want to use Keystone for creating new listings:
- Keystone Catalog Import
- Keystone Cost Import
You will need API credentials from the Keystone API team and FTPS credentials in order to use these automations. You must also request that your file includes the UPCcode and VCPN headers and that the IP address 52.207.122.19 be whitelisted for API and FTP access.
Drop Shipping Modes
There are two modes the Drop Shipping integration may operate in: Manual Drop Shipping and Automated Drop Shipping.
- Manual Drop Shipping - On the order page, you manually set order item vendor with a value of keystone for orders that may be sent to Keystone and then save the order.
- Automated Drop Shipping - If automated drop shipping is enabled, and keystonestock is the first stock control field (found under Settings > Selling > Stock Options > Stock Control Fields) that shows the product in stock, SureDone will automatically send the order to Keystone. In other words, let's say you have 2 vendors you can order the product from - XYZ and Keystone. In the stock control field setting (mentioned previously) it shows "xyzstock keystonestock", if xyzstock has positive stock AND keystonestock has positive stock (as seen in on the item page itself), we'll first fulfill using "xyz". If it shows "keystonestock xyzstock", and both distributors have the product in stock, we'll send the order to Keystone since it's listed first.
Keystone SKU Import
- This will create a "keystonesku" field in your account.
- The automation will attempt to link existing products in your account to those in the Keystone catalog by matching with the UPC of each of your products.
- Runs once every morning at the top of the hour.
Keystone Inventory Update
- This will create a "keystonestock" field in your account.
- The "keystonestock" field will automatically be added as a stock control field (found under Settings > Selling > Stock Options > Stock Control Fields). Any number in this field will be added to the stock sent to your marketplaces.
- Connects to Keystone and updates products with a matching "keystonesku" with the latest inventory levels for products with valid "keystonesku".
- Runs every hour at 5 minutes past the hour.
Keystone Inventory Update Full
- This will create a "keystonestock" field in your account.
- The "keystonestock" field will automatically be added as a stock control field (found under Settings > Selling > Stock Options > Stock Control Fields). Any number in this field will be added to the stock sent to your marketplaces.
- Connects to Keystone and updates products with a matching "keystonesku" with the latest inventory levels for products with valid "keystonesku".
- Runs once every morning at the top of the hour.
Keystone Inventory Update FTPS
- Note: Only use this integration if the Keystone Inventory Update Full integration does not work in your account per SureDone support and Keystone API support.
- This will create a "keystonestock" field in your account.
- The "keystonestock" field will automatically be added as a stock control field (found under Settings > Selling > Stock Options > Stock Control Fields). Any number in this field will be added to the stock sent to your marketplaces.
- Connects to Keystone and updates products with a matching "keystonesku" with the latest inventory levels for products with valid "keystonesku" and matches to the "VCPN" on the FTPS file.
- Runs once per week on Sunday morning at the top of the hour.
Keystone Orders Drop Shipping
- This automation creates orders that have a valid keystonesku in the product catalog.
- Runs every 5 minutes.
Keystone Orders Tracking Import
- Checks the Keystone system to see if an order has one or more tracking numbers assigned to it.
- If tracking numbers are assigned, they will be added to the order in SureDone and sent to the channel the order originated from.
- Runs every hour at the 45th minute.
Keystone Catalog Import
- This will create a "keystonesku" field in your account.
- Based on the settings chosen, will create or update products and import fields if they are manually created as custom fields before running:
- guid
- keystonesku
- upc
- vendorname
- vencode
- partnumber
- title
- longdescription
- jobberprice
- cost
- fedexable
- uspsable
- exeterqty
- midwestqty
- southeastqty
- texasqty
- californiaqty
- greatlakesqty
- pacificnwqty
- totalqty
- vcpn
- ntpvia
- upccode
- caseqty
- aaiacode
- mpn
- corecharge
- boxweight
- boxheight
- boxlength
- boxwidth
- isnonreturnable
- isnew
- supersededfrom
- prop65toxicity
- hazardousmaterial
- vendorcode
- Runs once every morning at the top of the hour.
Keystone Cost Import
- This will create a "keystonecost" field in your account.
- Will import the following SureDone fields from Keystone field if they are already created in SureDone:
- keystonecost: Cost
- keystonejobberprice: JobberPrice
- keystoneuspsable: USPSable
- keystoneupsable: UPSable
- keystoneupsgroundassessorial: UPS_Ground_Assessorial
- keystonefedexable: Fedexable
- keystonecorecharge: CoreCharge
- keystonecaseqty: CaseQty
- keystonehazardous: HazardousMaterial
- keystoneweight: Weight
- keystoneheight: Height
- keystonelength: Length
- keystonewidth: Width
- keystonemap: MAPretail
- keystoneusltl: US_LTL
- These fields can be used for internal purposes and in other rules automations.
- Runs every 3 hours at top of the hour.