AQ Sync Inventory Update Procedure

Owned by Stephen Juliano
Last updated: Feb 08, 2022 by Colleen Juliano
2 min read

Overview

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

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 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.

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.

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 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.