How to Create List of Items 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 CSV Template to download the template. This template will be downloaded in .csv file in your computer. 

    download_CSV.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 inputting the item name on a new row.

      D_Tabel.png
    • Column E (Commerce Item? Yes/ No) must be written Yes if the item is sold on the GoStore.

      E_Tabel.png

    • Column F (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.

      F_Tabel.png

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

      G_Tabel.png

    • Column H - K (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.

      HIJKL_Tabel.png

    • The L-R column is used for Retail products.
      • Column L (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 M (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 N (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 O (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 P (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 Q (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 R (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".

        L-R_Tabel.png

    • Column S (Variant Name) may be filled if the item has multiple variants.
      Note for Retail Product:
        • If you previously filled in the P (Color), Q (Size) and R (Material) columns, the format that automatically appears in the product variants is "Color"/"Size"/"Material" according to the data you fill in. For example: If the color is "Grey", the size is "Medium" and the material is "Cotton" then the name will automatically come out in Gray/Medium/Cotton format.
        • If column P, Q, R is filled in and column S is also filled in, the system will automatically change the variant name format to the format "Color"/"Size"/"Material" as in the example above.
        • If you want to customize the variant name, then you can leave the column P, Q, R, blank and only fill in the column S (Variant Name) according to your desired variant name data. For example "Celana pendek batik". The product will appear with the variant name "Celana pendek batik".

          PQRS_Tabel.png

    • Column T (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).

      T_Tabel.png

    • Column U - AF (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, you have to change it in Google Drive Link Generator (https://sites.google.com/site/gdocs2direct/home).

      U-Z_Tabel.png

    • Column AS-AX 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 AS (In Stock) berisi berapa kuantitas produk yang tersedia dalam stok. Isi dengan angka.
      • Column AT (Track Stock) is filled with "Yes" if you want to track the item stock. Otherwise, you may write "No".
      • Column AU (Track Alert) is filled with "Yes" if you want to get the stock alert notification through your email. Otherwise, you may write "No".
      • Column AV (Stock Alert) is filled with the number of stock limits as a warning that the stock is almost out.
      • Column AW (Track Cost) this column must be filled with "Yes" if you want to track the cost of goods (COGS). Otherwise, enter "No".
      • Column AX (Cost Amount) Cost of Goods. Do not include commas, periods, or any currency, include only the price. For example, 10000.AS_AX_Tabel.png

    • Column AZ-BM (Modifier) is 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 clicks Drop files to upload.

    Drop_Files.png


  11. Click Upload.

    Upload.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 in article How to Create Item in Moka.

Was this article helpful?
29 out of 63 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