In order to use SKU pricing within Expivi, you start by adjusting the hierarchy within your 3D file.
You can do this using a node with the suffix; part_”Sku code”_e. This SKU defining object always needs to have a 3d model underneath within the hierarchy.
As a rule of thumb, you can create a tiny geometric plane in order to achieve this without too many additional polygons being used. Place this geometry either far away or within the product geometry so it will not influence the customers shopping experience.
Adding Classes and Price matrix
After adjusting the hierarchy within your 3D file you can upload the file onto the platform. If you need more information on importing files into Expivi, please refer to the link below.
After the import, you need to create a class. You can find the classes menu on the left-hand side under the site tab:
In the classes menu, you can add one using the add button in the top right-hand corner. This will give you a new window in which you can give your class a name and type. The type needs to be Catalogue.
After you have created a class you also need to create a new ‘Price Group’ within the ‘Price Matrix’. You can this by heading over to the Price Matrix tab in the same tab as the Classes.
Similar to adding new classes, you can add a new Price Group within the Price Matrix tab. In the window add a name for your price group. Next, add the Class you created earlier. At this time you can skip the customer classes and priority and select save.
After creating the Price Group you can select it to open up the price rules. Here you can add new Price Rules.
There are two ways of adding new price rules
- Adding a single price rule at the time
You can do this by clicking on the +add button on the right-hand corner.
Adjust the SKU pattern according to the SKU’s that have been created within your 3D file and add the corresponding price (for each locale).
The ‘Unique’ checkbox is used in order to only calculate the given price once.
Meaning that even if multiple SKU are active, the price will only be added once.For the purpose of this ‘Basic guide, you can ignore the ‘Type’, ‘Components limit’ & ‘Condition Attribute’ fields.
- Bulk import multiple price rules by adding a CSV file with pricing information
Creating the .CSV File.
You can use any software similar to Excel + you need to be able to export in .CSV format.
The file needs to be at least two columns wide, however, there is no limit to the number of columns because you will be able to ‘ignore’ these while importing.
Column 1. = SKU Pattern
Column 2. = Base Price
There is however one restriction.
You can only import a file with around 800 rows at one time.
If you do import a higher amount of rows at a time you will notice that not all information will be transferred into the system.
(This is a limitation that is going to be improved on in the future)
Export the file to .csv from (for example) Excel or Google Sheets and import it into the pricing rules with the button in the top right-hand corner. This opens up a new window:
Inside the import window, you can change the delimiters and the currency. In the import fields, you can select the destinations:
SKU = SKU Patterns
Base Price = Price attached to SKU
You can ignore both None and Landen.
The samples are taken from the .csv file top line. Match your SKU code with the SKU destination and your price with the base price destination:
You may notice that the sample list will be cut short if more then 9 characters are in place, please keep this in mind while creating your Pricing Sheet.
Select import when you are done.
Refresh the page to see your SKU patterns and prices.
Adding Class to Product
Inside of your product in the basic information menu go to the Classes Tab and enter the class you just created:
Save changes after you entered the class.
Now you have added SKU pricing to your product!