StallSavior Excel Data Processing

StallSavior Excel Data Processing

Google Play:
https://play.google.com/store/apps/details?id=com.kagoo.StallSavior

Excel Data Processing Interface:

Tap the Export Excel to an SD card, you can choose to export Excel files.

After exporting the file will be generated in sdcard directory under StallSavior folder.
StallSavior ： inventory
StallSavior_spacename ：space
StallSavior_customer ：customer
StallSavior_order ：order
StallSavior_orderdetail ：orderdetail
StallSavior_purchase ：Procurement plan
StallSavior_record ：Into the ship records

Excel file generated content:
Brackets indicate the length of the character field to manually enter the time does not exceed the length, serial input is automatically generated from time.
Inventory Excel: product number, product name, stock quantity, unit cost required enter, storage spaces may enter.
Please note: Item number can not be repeated. Otherwise the import fails.

Customers Excel: Customer Code, Customer Name Required enter, phone, address may enter.
Excel manually enter the phone will automatically delete the first digit of 0, please note. Consider the following instructions to modify the settings.


Tap the top of the column, right-click → cell formatting.


Select the text category.


Re-enter can be reserved 0.


Orders Excel: Order number, shipping date is required. Customer code, customer name may enter.
Order number format：201307190001。Red：year。Blue：month。Orange：day。Green：Serial number。
Delivery Date：20130719。Red：year。Blue：month。Orange：day。
Enter 0 for Delivery Date is Non-delivery.

Orderdetail Excel: four fields must be entered.

Procurement plan Excel：Seven fields are must be entered.

Complete：0 - Not procurement, 1 - have been procured.

Record into the ship Exel： five fields must be entered.

Type：0 - Scanning purchase，1 - Scan shipments，2 - Manual Entry，3 - Manually shipping。

Time：20130719。Red：year。Blue：month。Orange：day。Green： Hour。Brown：Minute。

Tap the import Excel, choose to import Excel data.
Excel file must be in sdcard directory under StallSavior folder where otherwise the import fails.
Please note: When importing Excel data will overwrite the original.

Will have been exported to Excel send Email.
Excel file must be in sdcard directory under StallSavior folder, otherwise not be delivered.

Enter to send Email.

Select the application you want to transfer.
If you have installed Dropbox, Google Drive , you can choose to upload files to the cloud drive.

Dropbox app：
https://play.google.com/store/apps/details?id=com.dropbox.android
Google drive app：
https://play.google.com/store/apps/details?id=com.google.android.apps.docs