The "ifile" is a comma separated file used for inventory counting or any inventory adjustments when using a PDT (Portable Data Terminal). This is used for entering sales into the cash register, PO, and inventory counting. The "ifile" can be used also to bulk change counts without a PDT. Artisan looks up UPC, Alt Code 2 (Artisan bar codes) and Artisan item code (SKU).

Steps:

1- MAKE A BACKUP, this should always be done any time you are working with inventory and there are chances of making mistakes.

2- Using Microsoft Excel or any spreadsheet program make a CSV file name ifile.csv with two columns, preferably using Item Code for column A, but can also use UPC and ALT CODE 2, then Quantity for column B. DO NOT USE HEADERS IN EXCEL. See example below. For Item code POSKBD with a quantity of 50 units the following record should be on the .CSV file:

POSKBD(Column A) 50 (Column B)

POSKBD

50

3- Once you have made your import file in Excel save as Comma Separated Value (CSV) ifile.csv and save the ifile.csv to the Artisan data directory(C:\Artisan\Data) or \Artisan\Data\ depending where it resides.

Open up the "ifile" with notepad making sure Excel did not add leading 0 (zero) to the quantity. It should look similar to the format on the image below.

(if you get an error, make sure the ifile.csv is under the /Artisan/Data folder as explained above)

If location tracking is enabled or multi-store, select the correct site.

If a pop-up about clearing counts pops up, for the 1st time select "Yes" then "Yes" to the next one screen to confirm the clearing, if any more comes up say "No".Once at the ready to upload from the "ifile" window press Ctrl + F10.

Select correct site if location tracking is on. Select #1 If you only adjusted a batch of items and not the entire inventory (then go to next step) Or #2 accept the counts and zero out any thing that was not counted, use this option if you are adjusting all items and not just a batch of items.

8- If you did option #1 of the last step then you still need to zero the counts for the batch that was adjusted, i.e. vendor, category or group of items.

Put in the date you started counting even if it was a week ago, if it was just today then put today's date, then select the category or vendors you wish to zero out that were not counted, Artisan will give you a printable list Ctrl + P to review what will be zeroed, you should also before doing this step make another backup.

JavaScript must be enabled in order for you to use Knowledgebase Manager Pro. However, it seems JavaScript is either disabled or not supported by your browser. To use Knowledgebase Manager Pro, enable JavaScript by changing your browser options, then try again.
Learn more.