iPacky Dashboard→External data
This functionality allows you to read a Stocky purchase order/stock transfer CSV export, or an Inventory Planner purchase order export and use it to replenish your bin locations using a mobile device.
The native ones in Shopify do not support import/export, or have API access.
When entering the screen, you either must import a CSV file export, or open a file from the file list in the Actions menu.
Import from CSV
Select the CSV purchase order file you want to load into iPacky. After it has been loaded, you can Save to list.
Stocky purchase order
Must have these columns:
Purchase Order
SKU
Qty Ordered
Stocky stock transfer order
Must have these columns:
Stock Transfer
SKU
Quantity
Inventory planner purchase order
Must have these columns:
Ordered
SKU
We recommend this column also (which will speed up the loading)
ID
Save to list
After you have imported a CSV file, you can save it in the file list for easier and quicker access later on other devices. You must specify a name, and an optional description. This will then be saved into the iPacky file list.
You can print out the whole list (without images), or just print out the ones that has not been marked as completed.
Open from list
This will show a list of files that has been saved using Save to list. It’s highly recommended that you use Open from list since the checking status will be saved every 10 seconds, it’s quicker and easier, and you can also manually select Save status.
An opened file can look like this:
Clicking on the photo, it will show it full screen.
Clicking on the product name hyperlink will open Edit metafield for this product.
By clicking on the barcode hyperlink will open a dialog where you can enter/scan the product barcode, and enter the quantity. If the barcode is a match, iPacky will check if the quantity matches. If it’s a match of quantity, it will be checkmarked as correct. If the quantity entered is different from the ordered quantity, then the last column in the list will show the difference.
By clicking on the Qty column hyperlink, you can enter the received quantity. A check will be made against the ordered quantity, and it will either be checkmarked as correct, or the difference will be shown in the last column in the list.
You can also enter the product barcode in the input barcode field. It will then search for this barcode on any product in the list. If there is a match, it will open the dialog to enter the received quantity.
The checkbox is used to mark this line as completed. This status will be saved every 10 seconds if you open the file from the list. When you open the file from the list again, the saved status will be loaded, and you can continue from where you left off.
The number in parentheses in the Qty column shows the on-hand inventory in Shopify. The other number shows the quantity to be replenished.
To delete a file in the file list, select Open from list, and click on the trash icon. This is recommended when you’re finished with a file to clean up the list. These files will also be automatically deleted when they’re 14 days old.