How to Import GoStore Product Using Excel

You can upload item list or bulk items from Microsoft Excel in Moka backoffice easily. You can simply input your sales item in Excel and import the file into the backoffice. Your sales items will be directly registered in your Moka app.

To input a list of items, you will see two choices of import types:

  • Modify item library: This import type is used to add or replace some existing item data.

  • Replace Item library: This import type is used to remove all existing items and replace them with a new list of items that you will upload.

Note: Before importing items, you must first change the computer settings.

For Apple user:

  • Click System Preferences.
  • Click Language & Region.
  • Change Region to United States.
  • Click Advance.
  • Make sure Grouping (,) and Decimal (.)

For Windows user:

  • Open the Windows menu, then click Control Panel.
  • Click Regions.
  • Change the Format to English (United States) and Short date to DD-MM-YYYY.
  • Click OK.

Check out the video guide on how to enter a list of items from Excel here:



Here is the steps to import item using Excel in backoffice: 

  1. Login to Moka backoffice.

  2. Select menu LIBRARY.

  3. Choose Item Library. 

  4. Click Import/Export, then select Import Items. 

    Screen_Shot_2019-10-03_at_5.10.39_PM.png

  5. Select Modify Item Library to add new items or replace items that are already registered.

    Screen_Shot_2019-10-03_at_5.20.07_PM.png

    If you want to replace previous item data, select Replace Item Library. Then, click Next.

    cara_membuat_barang_denga_impor_excel_4.png

  6. Click Modify.

    import_item_dari_excel_mokapos.png

  7. Press Download Our Template if you do not have item data template. This template will be downloaded in .csv file in your computer. 

    cara_import_item_dari_excel_moka_pos__1_.png

  8. Open the file with Microsoft Excel and follow the steps how to fill in the template below: 
    • Column A (Internal ID Variant) will be generated automatically, therefore just leave it blank.  Do not edit the ID that is on the column.Import_Items_from_Excel_-_A1.png

    • Column B (Category) is optional and is applicable if you want to create a category. One category can be used for several items, but the text should should be identical. If you want to change it, you can edit the previous category name and paste the new category name on the previous column. 

      Import_Items_from_Excel_-_B1.png

    • Column C (SKU) is only applicable if your item have a barcode. SKU is the barcode number listed on your item.

      Click here if you need to input many item barcodes.
      Import_Items_from_Excel_-_C1.jpg

    • Column D (Items Name) is compulsory if you want to add a new item. The text (Do Not Edit) means you cannot change the item names that have been uploaded before, but you can add a new row by inputing the item name on a new row.
      Import_Items_from_Excel_-_D1.jpg

    • Column E (Small Image for POS) can be filled with links from cloud storage like Google Drive or others. Image size must be less than 250 KB with formats PNG, JPEG, BMP.
      Note: If the link is from Google Drive then you need to change it on the page Google Drive Link Generator (https://sites.google.com/site/gdocs2direct/home) so that the link can be read by the system.

      Import_Items_from_Excel_-_E1.png

    • Column F (Commerce Item? Yes/ No) must be written Yes if the item is sold on the GoStore.
      Import_Items_from_Excel_-_f1.jpg

    • Column G (Pre-order? Yes/No)can be selected Yes if the item is a product that is not yet available in inventory. If it is not a pre-order item then select No.
      Import_Items_from_Excel_-_G1.jpg

    • Column H (Processing Days) is filled with the number of how many days it will take to process the pre-order item.
      Import_Items_from_Excel_-_H1.jpg

    • Column I - L (Weight, Length, Width, Height) must be filled in for it to appear on the GoStore. These columns are filled with numbers only (without units) and not decimal numbers. If it doesn't have a value, it can be written as 0.
      Import_Items_from_Excel_-_I_to_L1.jpg

    • The M-S column is used for Retail products.
      • Column M (Condition) is specifically for Retail products and must be filled in. The column shows the condition of the product. Only allowed values "New", 'Refurbished", "Used".
      • Column N (Brand Name)shows the brand of the item. If the brand already exists in the system, it will be overwritten with the name used in this sheet. To sell products online, this field is mandatory.
      • Column O (Gender) for Retail (Clothing and Accessories). Can be filled with the gender of the target user of the product. You can fill only with "female", "male", "unisex".
      • Column P (Age Group) for Retail merchants (Clothing and Accessories). Can be filled with the target age group of product users. You can fill only with "adult", 'all ages", "teen', "kids", "toddler", "infant", "newborn".
      • Column Q (Color)for Retail merchants (Clothing and Accessories). The column shows the item's color variant. If there are multiple colors, use a different row for each color. e.g. "Red".
      • Column R (Size) For Retail merchants (Clothing and Accessories). The column shows the item size variant. If there are multiple sizes, use a different row for each size. e.g. "Medium".
      • Column S (Material) For Retail merchants (Clothing and Accessories). The column shows the material variant of the item. If there are multiple ingredients, use a different row for each ingredient. e.g. "Cotton".
        M-S.png
    • Column T (Variant Name) may be filled if the item has several variants. Copy and paste Column B-D in a new row according to the number of variants, and differentiate the names of the variants.
      Import_Items_from_Excel_-_T.jpg
    • Column U (Basic - Price) fill in the column with numbers only, without commas, periods, or currency writing. (For those who want to change the price of the item, enter the price of the new variant item in the column).
      Import_Items_from_Excel_-_U.jpg
    • Column V - AG (Image) is 12 columns to fill with image links. You need to add at least 1 product image. The minimum image size is 500x500 pixels and a maximum of 8 MB. The formats used are: PNG, JPEG, BMP. Use a link from Google Drive or another cloud system to add an image link.
      Note: If the link is from
      Google Drive maka Anda perlu untuk mengubahnya di halaman Google Drive Link Generator (https://sites.google.com/site/gdocs2direct/home).
      Import_Items_from_Excel_-_V.jpg

    • Column AU-AZ is a column that contains item stock data. If you are not using the Track Stock feature, skip this column. If you want to enable the Track Stock feature, follow these steps:
      • Column AU (In Stock) berisi berapa kuantitas produk yang tersedia dalam stok. Isi dengan angka.
      • Column AV (Track Stock) is filled with "Yes" if you want to track the item stock. Otherwise you may write "No".
      • Column AW (Track Alert) is filled with "Yes" if you want to get stock alert notification through your email. Otherwise you may write "No".
      • Column AX (Stock Alert) this is filled with the amount of stock limits as a warning that the stock is almost out.
      • Column AY (Track Cost) this column must be filled with "Yes" if you want to track the cost of goods (COGS) . Otherwise, enter "No".
      • Column AZ (Cost Amount) Cost of Goods. Do not include commas, periods or any currency, include only the price. For example, 10000.

        AU_-_AZ.png
    • Column BA-BN (Modifier) usually used for food and beverage products. This field is optional, can be filled or not.
  9. Save the file in the format .csv.

  10. Repeat steps 1-7 and click Drop files to upload.

    import_item_excel_mokapos__1_.png

  11. Click Upload.

    import_item_excel_moka_pos__1_.png

In addition to importing products with Excel, if there are only a few products, you can add products one by one according to the following steps.


Read the next articles:

Was this article helpful?
1 out of 1 found this helpful

Comments

0 comments

Please sign in to leave a comment.

Still Have Questions?

Our customer care team is here for you!

Contact Us