Using Quickbooks Desktop?

AMP has AMP Connect, which is a full integration with Quickbooks Desktop that allows you to pull products, customers, reps, orders, and invoices directly from Quickbooks to keep AMP up-to-date automatically. AMP Connect also sends orders written through AMP directly into Quickbooks to be processed. Ask AMP (support@amptab.com) about AMP Connect if you're interested.

 

For all other ERP systems use AMP's API

AMP has an accessible API that can be used to update AMP from your system and send orders written in AMP automatically to your system. Setting this up normally is a small project for an IT team or contractor, and the AMP team can walk you through 100% of the way! Contact AMP (support@amptab.com) today to set up a quick call to discuss in more detail.

 

Sending data from ERP system to AMP

What data can be sent to AMP?

Products – For populating the product catalog in AMP. The file usually includes inventory, prices, product descriptions, etc.

Orders – For displaying order history (including orders placed outside of AMP) to reps and customers. The file can include a status column (OPEN, INVOICED, CLOSED, etc.).

Invoices – For displaying invoice history to reps and customers.

Dealers – For keeping reps’ customer lists updated in AMP and granting AMP access to customers.

Reps – For keeping rep list updated in AMP.

 

How is data sent to AMP?

Data is sent in CSV file as an HTTP POST request to an AMP HTTP endpoint URL. Data can also be sent as an attached file in an email, provided the resulting message size is less than the common email limit of 25MB. It doesn't necessarily have to be CSV format, either. Since we have a JSON to CSV recast, we can also accept JSON, if formatted as shown in this example:


1) The file must contain valid JSON and nothing else (can be checked at https://jsononline.net/json-validator)
2) The file must start and end with square brackets (indicating a JSON array)
3) inside the square brackets should be a comma-separated series of JSON objects (each enclosed by curly brackets), one per line of the CSV table that the file will get converted into. The field names will become column headers in the resulting CSV. Each of those JSON objects must have the same set of fields in it, as shown:

[
{
"SKU": "12345A",
"Desc":"Desk Chair",
"Inventory": "1",
"Price": "154.32",
"Romance":"This \"ordinary-looking\" desk chair will change your life, forever."
},
{
"SKU": "23456B",
"Desc":"Big Comfy Sofa",
"Inventory":"5",
"Price": "2125",
"Romance":"You will never look at sofas the same after sitting on this one."
},
{
"SKU": "34567",
"Desc":"Dining Table",
"Inventory":"9",
"Price":"780.01",
"Romance":"The best dining table anywhere. Suits any space, even outer space."
}
]


How should the files be formatted and laid out?

The file should be a CSV with column headers that match what has already been manually uploaded into AMP (Or JSON as noted above). Templates for each file are available upon request.

 

What are the steps for setting it up?

  • Create repeatable procedure for exporting a CSV file with desired data and format from your ERP system (Crystal reports and SSRS are popular solutions).
  • Schedule the creation of this CSV file at the frequency you desire.
  • Schedule execution of the provided AMP API Script using the provided AMP API endpoint URL and path to your file (Windows Task Scheduler or Automator for Mac are popular solutions here).*

*See detailed documentation for in-depth instructions: From AMP CMS > choose your company’s name from the navigation bar > click ‘Manage Backend API’ in the Company Profile section

 

Can I update the current table in AMP, or do I need to replace it every time?

Products, dealers, and reps can be merged with the existing table in AMP. AMP will update information for SKUs that already exist in AMP and add new SKUs for those that don’t yet exist. This merging allows you to update AMP from multiple sources. For instance, you may want to update only certain columns in the products table from a source of pricing and separately from a source of inventory. Merge or Replace is indicated on each endpoint in the list of available endpoints.

 

Sending data from AMP to ERP system

What data can be sent from AMP to an ERP system? 

Orders – These are the last 30 days of orders completed in AMP.

 

How is data sent to ERP system?

A CSV file can be read from AMP using an HTTP GET request to an AMP HTTP endpoint URL.

 

What format does AMP produce?

Amp produces a CSV file with a header row for each order followed by the line item rows for that order. Header row and line item rows of an order share an ORDER ID. (See in-depth order format document for more detail).