How to add stones in GemCloud through Excel import?

How to add stones in GemCloud through Excel import?

Introduction

GemCloud is a comprehensive cloud-based platform designed for managing gemstone inventories efficiently. One of its key features is the ability to add stones to the inventory through Excel file uploads. This method streamlines the process, allowing users to import their inventories quickly and accurately. Below is a step-by-step guide on how to add stones to your GemCloud inventory using an Excel upload.

Step-by-Step Guide to Adding Stones to Inventory via Excel Import

Step 1: Go to the Inventory Catalog Option

  1. Begin by navigating to the "Inventory catalog" option within the GemCloud interface.
  2. From the inventory catalog, select the "My Inventory" option to access your personal inventory details.

Step 2: Click on the Import Button

  • Locate the import button situated at the top right corner of the screen and click on it.


Step 3: Start Excel Upload
  1. Initiate the process for uploading Excel files by selecting the Products Import your products such as gemstones option.


Step 4: Select Excel Template Type
  1. You can download an Excel template from the system for the category you want to import.

Step 5:  Template - Entering Sub-Category
  1. After downloading the Excel file, please fill out your stone details. It is mandatory to enter the sub-category in the Excel file. 
  2. Once fill all the details please save your excel file.

Step 6: Select Upload Type

  1. Choose the type of upload you wish to perform. This could be a new inventory or an update to the existing inventory.
  2. If you are adding new stones, select the "New Inventory" and click on "Proceed to upload".

Step 7: Select Import Category

  • Choose the appropriate import category that matches the type of stones you are uploading.

Step 8: Mark the Checklist and Scroll Down

  • Click on the "Drop file or browse" button, then select the Excel file from your computer that contains the inventory data and click on "Proceed to Upload".

Step 9: Map the Data Fields

  • Map the columns in your Excel file to the corresponding fields in the GemCloud system. and at last click "Finish upload", This step ensures that the data is correctly interpreted and stored.

Step 10: Complete the Upload

  • Your file will be uploaded, and the stones will be added to your inventory.

Conclusion

Adding stones to your GemCloud inventory via Excel upload is a straight forward process that involves several steps, from accessing the inventory catalog to mapping the data fields. By following these steps carefully, you can ensure that your inventory is updated accurately and efficiently. This feature enhances the ease of managing large inventories, saving time and reducing the likelihood of errors.


    • Related Articles

    • How to Activate Deleted Stones in GemCloud?

      GemCloud allows users to manage their inventory efficiently, including the reactivation of deleted stones. This guide will walk you through the process of activating deleted stones from the archived section. Step-by-Step Guide Step 1: Navigate to the ...

    • How to Partially Send Stones from a Parcel on Invoice?

      This guide will help you understand how to partially send stones from a parcel Invoice using the GemCloud Trader ERP system. Follow the steps below and refer to the accompanying GIFs for visual guidance. Step 1: Access Your Inventory Navigate to the ...

    • How to Add Filters in the Archived Section in GemCloud?

      Filters are a powerful tool that help you quickly locate specific stones within the archived section. This guide will walk you through the steps to apply filters effectively. Step-by-Step Guide Step 1: Navigate to the Archived Section Log in to ...

    • How to Split a Stone in GemCloud?

      Splitting a stone in GemCloud allows you to create multiple child stones from a single parent stone, ensuring accurate tracking of quantities, weight, and costs. This guide will walk you through the process of splitting a stone in your inventory. ...

    • How to export your memo in PDF, Word, and in Excel Format?

      Introduction: In today's digital age, efficient document management is crucial for businesses to streamline operations and enhance productivity. GemCloud offers a user-friendly platform that allows you to export memos into PDF format effortlessly. ...