Google Sheets product upload

Linking products via Google Sheets is easy!

Seems like you have a list of products that you would like to use to upload your products!

It might even be an Excel sheet that you want to automatically sync with Nulisec.

When you pick the I do not use any E-shop/ERP/SAP system you will be prompt by a suggestion that looks like Fig. 2 in the I want to start selling on Nulisec pt.2. Feel free to click on the >Next step

Once, you are done with the onboarding process, you will land on the Dashboard page.

Uploading products using Google Sheets

First, you will need to have an empty Google Sheet file opened so that you can prepare the sheet in such a way that our marketplace can read it.

Once you have a Google Sheets opened, you will find the Google Sheets importing tool in the Store management window under the Automation section. Within that tool you will notice 2 main headers, Google Sheets and Need help setting up Google Sheets?

Open up the configurations page by clicking on the yellow Configure button.

Fig 1. Google Sheets importing section

The Need help setting up Google Sheets section in Google Sheets section does not actually help you set up the Google Sheets import function on your own. When you download the excel file and email it to us, per the instructions written on the page, we would take care of the entire set up.

You know what they say; "give a (wo)man a fish and you feed them for a day."

In this guide, I will attempt to teach you how to fish.

Now that you have both the Google Sheets and the Configure page opened. You're ready to start filling in the information.

The question is, what do I put in each of these columns?

  • name

    • the name of the product that will be displayed to buyers. The naming convention will be explained in another post later.

  • description

    • any text format information that will help the potential buyer find the product within the platform search

  • details

    • any html format information that will help the potential buyer find the product and make purchasing decisions

  • quantity_in_stock

    • the total amount of the given item that you currently have available for sale

  • minimum_order_quantity

    • the lowest set amount of stock that you are willing to sell

  • barcode

    • a standard used in global trade to identify a specific retail product type, in a specific packaging configuration, from a specific manufacturer

  • catalogue_number

    • an identification number used to help current customers identify your product

  • categories

    • a name for a group of products with shared characteristics

      • A product can be assigned to multiple categories by adding a | for example, footware|male

  • price.

    • the amount of money expected for the product

      • In each price column, you must indicate the price level after the dot . such as price.vip

We allow you to upload multiple prices for a single product in case you have different price levels.

For example, I have 2 sets of prices; 1 for regular customers and 1 for my VIPs for a single product.

If my price levels are called regular customers and vip. I would upload them by creating a column labelled as price.regular_customers and another column labelledprice.vip

  • old_price.

    • the amount of money that will be crossed out to show a price change

      • In each price column, you must indicate the price level after the dot . such as old_price.vip

  • quantity_discount

    • an incentive offered to a buyer that results in a decreased cost per unit of goods when purchased in greater numbers

      • The format is quantity|price for example, 100|1.5 for 100 units the price will be €1.5 assuming the price is in euros

  • property.

    • a pair of information about the product that helps the user make a purchasing decision such as pieces on a pallet

  • option.

    • a selection of variations of the product such as its color or size

  • unit

    • the product unit is the units of measurement used for items on our marketplace (i.e. pieces, cases, pallets)

  • base_units_in_product_unit

    • the amount equivalent of a given product unit in another unit of measurement

      • for example, a piece (as a unit) has 275ml so the base_units_in_product_unit column would have 275 for that given item

  • vatrate

    • is the percentage value of a consumption tax placed on a product

  • photo

    • the URL of the photo you would like to upload. That's right, we will find it and upload it for you as long as we can find it on the web.

Once you have all of those columns filled in, you will just need to pair the file with our system.

You will be able to upload all the product information in this new Google Sheet onto the marketplace by first publishing it onto the web.

To do so, find the Publish to the web button under the File section in the sheet. Once published, copy the URL link you will find in the dialogue.

Unsure of what a URL link is? Look for the https:// prefix

Fig 2.

Paste the link you just copied from the Google Sheet into the Configuration page inside the Google Sheets tab and press on Update Configuration

Now you are ready to press that mighty Sync now and voila! all your products are being uploaded.