Integrating with Sku Grid using our Hosted File URL system allows you to sync your cost values set in their system either every 1, 12, or 24 hours. Costs already set in your Informed account will be overridden by values set in Sku Grid. If a cost is manually changed in Informed, the cost will be overridden in the next update from Sku Grid.
Setting up your integration with Sku Grid is a two-step process, starting with setting up the integration in Sku Grid before adding your hosted file URL in Informed.
Setting up your integration in Sku Grid
In order to setup your Sku Grid integration, you will need to enable some settings in Sku Grid and obtain your file URL to add to Informed:
- In your Sku Grid account, navigate to your Amazon Marketplace Settings
- Set Auto Update Amazon Stock = Yes and Auto Update Amazon Price = No
- Delete the long formula written under Calculating Amazon's Selling Price. You will need to add a formula here, if you'd like to pass the supplier price and shipping costs only, Sku Grid recommends the following formula: vendor_price + vendor_shipping
- Under Informed.co Integration select Yes for Export In Stock Items to Informed
- Next, select what you want to use as the SKU variable in your generated file, we recommend using Amazon's SKU as the SKU field is required when updating a cost.
- You should see a .csv link appear, copy this link as it will need to be entered in Informed
Adding your Sku Grid hosted file URL in Informed
Once you've chosen the correct settings in Sku Grid and obtained your URL, you will need to complete the integration by adding the URL as a hosted file in Informed:
- In Informed, navigate to your Uploads Page
- Paste your Sku Grid URL (copied in Step 6 above) and paste it in the File URL field as shown below
- Select the Upload Frequency of your choosing (every 1, 12, or 24 hours)
- Select Save, your cost prices should sync automatically going forward as per your select upload frequency