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.
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.
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
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
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.