Adding a new Pricelist and editing in bulk

Modified on Mon, 18 Mar 2024 at 01:17 PM

The following steps will guide you to create a new pricelist in Skynamo as well as adding prices to this pricelist. Firstly, you will have to create the new price list on Skynamo Insights (i.e. Web portal). Then, you will have to download and populate the Excel spreadsheet of your products. Lastly, your will have to import your newly populated spreadsheet.

Creating the new price list

Initially, you will simply create the price list on Skynamo. Only in the next step will you specify the costing of products on the new price list. This section explains how to create a price list.

First, navigate to your Products tab and select Pricelists to the left:

A screenshot of a computer

Description automatically generated

Then proceed to click the blue Add price list button to the right of the screen.

A screenshot of a computer

Description automatically generated


Once you have chosen this option the following dialogue page will open. You can now add the pricelist name. You can also choose if the pricelist includes or excludes VAT:


A screenshot of a computer

Description automatically generated


Adding the correct product prices for your new price list

After you have created the new price list, this list will appear if you export your product, but there will not be any values for the new price list. In this step, we explain how you can enter the correct values for each product.

First, navigate to your products tab. Click on the download all button to download the Excel file.


A screenshot of a computer

Description automatically generated

 

An Excel spreadsheet will be downloaded of your complete product database. On this spreadsheet, all the different price lists that you have previously uploaded will also appear. Click on the downloaded file.

A white rectangular sign with black text

Description automatically generated

 

On the open Excel sheet, you will see different columns with the product details, that is then followed by the different pricelists that have been added for your company - in this example they are Wholesale, Minimum and Cost. Your newly created pricelist - CBA Cost Price - will also be included. Notice that the other price lists have values, but the new one does not yet have any values. (Wholesale, Minimum and Cost are all price lists that have previously imported for this example - you will thus not have these columns, unless you have price lists with those names.)


Now, you can add the prices for this pricelist, by entering the values in the column of the new price list.


A screenshot of a computer

Description automatically generated

Once you have updated the Excel sheet, save it where you will easily find it again.


Importing the price list spreadsheet

You will now have to import the newly populated spreadsheet. This section shows this process.

On Skynamo navigate to your Settings:

A purple and white icon

Description automatically generated with medium confidence

 

Navigate to Imports. From the Imports list choose import products on the right-hand side:


A screenshot of a cell phone

Description automatically generated

 

This will now open your dialogue to import your product information, which includes your new pricelist. Click on Browse to browse for the Excel sheet you created, and then on File Select to start the importing process. Your pricelist will now be visible to your users once their devices have synced:

A screenshot of a computer

Description automatically generated

 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article