Using Google Spreadsheet to import items

If you have a lot of items to enter on the app, you can batch import these items.
Here’s what you need to do :

1. Export CSV Data
   • This gives you a template that you can edit
   • Follow these steps to do the export:  http://support.mobilebizco.com/importing-exporting-data/export-csv-data.html
     
2. Locate your csv file
   • Sdcard – On your device, go to the folder
     • On Android 10 and above: sdcard/Android/data/com.mobilebizco.android.mobilebiz/files/mobilebiz-co/shared/csv
     • On Android 9 and below: sdcard/mobilebiz-co/shared/csv
   • Dropbox – Login to your dropbox account and go to /mobilebiz-co/shared/csv folder.
3. Open your csv file using a textedit (ex. notepad)

Then,

4. Go to your Google Drive and create a new spreadsheet.

5. Update the name of the spreadsheet.

6. Go back to your texteditor and copy the whole content.
– Then paste it on the spreadsheet.
– You can now use this spreadsheet to modify your item fields. (ex. item price)

7. After making the changes on the spreadsheet, you need to save and download the file.
– Click on “File” > “Download as” > “Plain text”. This will create and download the file. (ex. item_list.tsv)

8. Then Transfer this file back to either the Sdcard or Dropbox.

9. Import back the updated csv file to update the records.
Click here to see the specific steps to import back to MobileBiz Co