AQ Sync Inventory Update Procedure

Overview

***As of 1/1/22, this Procedure is replaced by AQ API Update Procedure***

The AQ Sync function allows you to pull the data directly from AQ. This saves the need for moving files around, but does require upkeep/management before you can run the update. At one time, part of this process was automated, but it was causing issues. We have a new/cleaner way of doing this in the latest, so we will not be correcting this older method.

This guide assumes your inventory is properly setup and linked with AQ.

Please see the AQ Sync Troubleshooting guide if you are having issues seeing your manufacturers or items.

Detail

Updating Last Updated Date / Manufacturer List

The “Last Updated Date” used to be updated with the automated process. Now that it is not running, you will need to use the “Pull Manufacturers” button under the API tab (INV Tab in older versions) of the SYS>DBA Admin screen.

Open

Update Pricing

After updating the Manufacturer header data, we still need to sync the Manufacturers with updated items.

Under INV>AQ Interface>AQ Sync Inventory, it lists of your MFG’s. Hit the Sync button on any you want to update. Another pop-up will come up. Select “AQ API”.

This may take a few minutes, so if it is spinning, just let it run. If you start clicking, it may seem like the page froze, but it is likely still running.

Once it says it finished, the prices should be up-to-date.

Open

Troubleshooting

If Syncing the “AQ API” didn’t update the price, it is possible the Manufacturer had updated their UOM data. Try running the “AQ UOM” sync on the Sync Pop-up, then running the “AQ API” once again.

If you are still having issues, consult the AQ Sync Troubleshooting guide to make sure the inventory is setup correctly.

If the change was very recent, it is possible that the change hasn’t been sent to us from AQ. Until they update that information, there isn’t anything we can do. May just want to check tomorrow.