Click >Maintenance >Acme Importer

 

Set Import Type to "Inventory Data" to import new items, and update existing items. Fields include List Price, On Hand Quantity, On Hand Adjustment and more.

 

Acme includes multiple predefined definitions for import of inventory data, use them or create your own.

 

 

 

 

 

NOTE the importer does not require strict length item numbers for matching to existing items. It takes the incoming data which could be 10, 11 or 12 digits in length and puts them into a common format, with and without the check digits and then it tries to get a hit in existing Acme data.

 

If the importer gets a hit the record may be updated, if there is no hit a new item record may be added. This behavior is dependent on the "Record Update Mode" you select. See above screen-shot. If a new record is added it will use as many digits from the incoming data source as possible.

 

 

 

 

Descriptions: You can import Item Description, Ticket Description or both.

 

TIP: Import item description to Ticket Description (TICKDESC), if the item is NEW both will be populated. If the item is being updated, only TICKDESC will be updated.

 

You could do the opposite as well, but it is more likely that people will hand edit the Item Description than the Ticket Description.

 

Item Description is used on inventory grids (pick lists) and in Acme Super Find.

Ticket Description prints on receipts.

 

Department: Department is NOT required in your import file, but all items will have a department.  If the column is excluded a Department called GENMDSE / "General Merchandise" will be used. This value is also used as a default value if your import file has a Department column that is not populated for all records. This gives you an easy manner to identify those items in the Inventory Nav View and fix them.

 

If your import file contains a Department column the Departments must exist in Acme, set them up prior to import.

 

Acme only imports single level departments, it does not import sub-departments. Inquire for assistance.

 

On Hand Quantity: There are two ways to change on hand counts during import...

 

onhandqty -replaces the on hand quantity

 

onhandadj -adds to (or if negative subtracts from) the on hand quantity in Acme. If you subtract more than what exist, the on hand quantity will go negative.

 

Note, Acme also has Physical Inventory work-flows.

 

Preferred PLU: If a single item is on more than one incoming row, the last Preferred PLU designator imported wins.

 

Item Control: The following values are valid for ITEMCTRL, you may use the single letter the single letter plus a few characters to make it more intuitive. The importer only pays attention to the first character.

 

"P" for "Stop On Price"

"Q" for"Stop On Qty"

"S" for "Wait For Scale"

"T" for "Wait For Scale w/Tare"

"G" for "Giveaway"

 

 

Button(s) not active?  Close other Acme screens. Make sure all fields have valid values. If the issue continues validate for required columns.

 

If your import will affect on hand quantities or average cost you will be asked to confirm your choices:

 

 

After import you should get exclusive use of Acme (no other users in the program on other computers) and then click >Maintenance >Reindex

 

When reindex is complete, go into Acme Data Pump >Utilities >Update Super Find Dictionary. Failure to do so will cause new or updated item descriptions to be omitted from Superfind results.

 

 

Related Topics

 

Import SIL Inventory Files

 

Acme Importer

 

Import Pricing Data

Import Vendor Data

Import Customer Data

Import Contact Data