WEBVTT 00:00:00.000 --> 00:00:04.300 Hi. Welcome to XMPie uStore version 15. 00:00:04.300 --> 00:00:08.566 This release of uStore introduces three new features: 00:00:08.566 --> 00:00:14.732 The major development focus for this version was to introduce a new Excel Product Pricing template 00:00:14.733 --> 00:00:19.833 which provides a lot of new pricing functionality for static products. 00:00:19.833 --> 00:00:25.199 For example, the new spreadsheet allows you to return a price based on the cheapest option 00:00:25.200 --> 00:00:30.266 when the customer has not yet set all properties available on the product. 00:00:30.266 --> 00:00:41.299 Also, it allows you to include or exclude or even hide product properties based on the user, product, or even other property selections. 00:00:41.300 --> 00:00:47.366 This is a huge feature with plenty of use cases, so I will explain more later. 00:00:47.366 --> 00:00:56.399 Second was to add the ability for customers to add comments to the order when checking out. This was another frequently requested feature. 00:00:56.400 --> 00:01:05.400 Previously comments were only available on each individual product added to the cart. I will demonstrate this in just a moment. 00:01:05.400 --> 00:01:14.066 The last change introduced in version 15 is in the Presets where you find and install the latest uStore patches. 00:01:14.066 --> 00:01:22.432 Right now, there are no patches available for version 15, so let me swap to an earlier version to explain the feature. 00:01:22.433 --> 00:01:30.166 Here, you can see all the available patches and at the bottom the last patch will upgrade uStore to the next version. 00:01:30.166 --> 00:01:38.899 In some cases, customers will have custom plugins installed – for example plugins developed by XMPie Professional Services 00:01:38.900 --> 00:01:41.766 or 3rd party developers. 00:01:41.766 --> 00:01:47.466 These plugins may also need to be updated and certainly tested on a new version of uStore 00:01:47.466 --> 00:01:50.932 before you upgrade your production uStore server. 00:01:50.933 --> 00:01:59.166 So, the new feature introduced in version 15 is for the "Install updates" button to work in two stages. 00:01:59.166 --> 00:02:06.566 If there are patches available for the current version, the first click of the button will install only the patches. 00:02:06.566 --> 00:02:12.499 Clicking the button again once all patches are installed will upgrade to the next version. 00:02:12.500 --> 00:02:18.433 In a future version we will separate this into two buttons for more clarity. 00:02:18.433 --> 00:02:25.333 Naturally, you should only upgrade to the new version if you are not using custom .net uStore plugins, 00:02:25.333 --> 00:02:31.499 or you have already tested the plugins on a development server with the new uStore version, 00:02:31.500 --> 00:02:37.566 or you have new plugin versions ready to install after the uStore upgrade. 00:02:37.566 --> 00:02:42.666 Let's go back to the new order comment feature and take a closer look. 00:02:42.666 --> 00:02:46.832 In the uStore Admin back office when setting up the store 00:02:46.833 --> 00:02:55.333 the administrator can enable the Order Comment feature here on the Appearance Tab for each store separately. 00:02:55.333 --> 00:02:59.899 00:02:59.900 --> 00:03:06.266 When the Order Comment is enabled on the store, during the checkout process customers can enter a comment 00:03:06.266 --> 00:03:11.199 which is assigned to the order as a whole. 00:03:11.200 --> 00:03:16.500 00:03:16.500 --> 00:03:27.266 The comment is not automatically added to the store receipt, but if desired, the administrator can add it easily in the back office. 00:03:27.266 --> 00:03:33.966 Simply type a label and insert the variable into the layout. 00:03:33.966 --> 00:03:43.232 00:03:43.233 --> 00:03:51.066 Customers are able to see their comments in the order history. 00:03:51.066 --> 00:03:59.199 In the back office, the customer's comments will be visible to store administrators on the order details page. 00:03:59.200 --> 00:04:04.066 And on the order item detail page. 00:04:04.066 --> 00:04:07.966 Also, the Job ticket will include the order comment. 00:04:07.966 --> 00:04:17.866 And if the store is configured to export order details to XML or cXML, the comment will be available as a parameter. 00:04:17.866 --> 00:04:24.766 00:04:24.766 --> 00:04:31.899 And if you are using the default Detailed Order Confirmation Email template, the order comment will be in the email. 00:04:31.900 --> 00:04:38.866 But, if you are using a custom email template, you will need to edit the template to add this new variable. 00:04:38.866 --> 00:04:44.966 The major new feature of the version is a significant change to the Excel Product Pricing template 00:04:44.966 --> 00:04:54.499 to include much more information to help with calculating the price and for controlling the product properties and their available options. 00:04:54.500 --> 00:04:59.866 You can see that there are many more input values in this new Excel file. 00:04:59.866 --> 00:05:09.466 The price calculations can now use information about the company, user, or user group membership when calculating prices. 00:05:09.466 --> 00:05:15.032 Secondly, you can see a new table of information about product properties. 00:05:15.033 --> 00:05:20.699 Previously, you would have to create special named cells in the spreadsheet for each property, 00:05:20.700 --> 00:05:28.900 and you could only get the value that the customer selected or entered for that property to use in the calculations. 00:05:28.900 --> 00:05:35.166 Now, using this new table, you simply need to enter the name of the property in the cell, 00:05:35.166 --> 00:05:39.532 and uStore will enter information into the input values. 00:05:39.533 --> 00:05:46.999 Initially, in version 15, the features introduced in the properties table will only be available only for Static products 00:05:47.000 --> 00:05:53.300 in stores that use the single page ordering workflow and uStore NG mode. 00:05:53.300 --> 00:06:00.333 Composite and Dynamic product types will start to use the new Excel properties feature in a future version. 00:06:00.333 --> 00:06:03.966 Let me explain some of these new features. 00:06:03.966 --> 00:06:10.432 This field indicates whether the property was used in the product that is currently being priced – 00:06:10.433 --> 00:06:14.799 because one Excel file can be used to price many products. 00:06:14.800 --> 00:06:21.200 For example, all the products linked to a product profile, or you can set a store-level spreadsheet 00:06:21.200 --> 00:06:28.466 that can price all products in the store that are set to use Excel instead of the built-in pricing engine. 00:06:28.466 --> 00:06:35.599 Best practices to get the most out of Excel-based pricing is explained in a separate video. 00:06:35.600 --> 00:06:42.733 And this field will hold the value entered or selected by the customer for the product currently being priced. 00:06:42.733 --> 00:06:50.866 You can manually enter values here to test your spreadsheet, but uStore will override the input cell values. 00:06:50.866 --> 00:07:00.432 You can also use these new output values to include, exclude or select specific property values to display to the user, 00:07:00.433 --> 00:07:04.933 or to hide the property under certain conditions. 00:07:04.933 --> 00:07:17.233 This is explained in a separate video that goes into more depth about customizing the Excel Pricing Template. 00:07:17.233 --> 00:07:23.699 The price and cost calculation area includes a column to define the cheapest option. 00:07:23.700 --> 00:07:30.633 This is used to calculate the price when the customer has not yet made a selection for this property. 00:07:30.633 --> 00:07:35.466 Again, this is described in more detail in a separate video. 00:07:35.466 --> 00:07:40.466 This column is automatically calculated. You should not change this formula. 00:07:40.466 --> 00:07:45.832 The cell will hold the value of the property that will be used in the pricing calculation. 00:07:45.833 --> 00:07:52.533 If the customer has selected a value, uStore will enter it here, and the formula will get that value 00:07:52.533 --> 00:07:59.133 unless the customer selection is overridden by a rule or formula that sets the selection here. 00:07:59.133 --> 00:08:03.666 If the customer's selection and the administrator's selection are both empty, 00:08:03.666 --> 00:08:08.532 then the cheapest property will be used so that a price can be returned. 00:08:08.533 --> 00:08:16.833 These cells are where you should add your formulas for calculating the price, based on the Value for Calculation. 00:08:16.833 --> 00:08:22.399 These total cells will automatically sum values in the above columns, 00:08:22.400 --> 00:08:27.633 but only if the property is used in the product that is currently being priced. 00:08:27.633 --> 00:08:31.699 Again, you should not need to change these formulas. 00:08:31.700 --> 00:08:36.400 Each of the column headers has a note to help explain its purpose. 00:08:36.400 --> 00:08:46.733 If you need to add more than four properties into the spreadsheet, simply right-click on a row, select Insert and then Table rows above. 00:08:46.733 --> 00:08:53.499 If you do this on the last row of the table, you can insert the row either above or below. 00:08:53.500 --> 00:08:57.166 Now, a quick discussion about backward compatibility. 00:08:57.166 --> 00:09:02.699 If you are already using Excel-based product pricing with an earlier uStore version, 00:09:02.700 --> 00:09:10.266 when you upgrade to version 15, your existing Excel pricing files will continue to work perfectly fine. 00:09:10.266 --> 00:09:18.466 But you will not be able to take advantage of the new property table until you change to the new Excel template. 00:09:18.466 --> 00:09:28.066 Unfortunately, there is no automated way to move the products table and new input cells into your existing Excel pricing file. 00:09:28.066 --> 00:09:34.432 The advice from R&D is that it will be easiest to download the new default pricing template 00:09:34.433 --> 00:09:40.899 and copy your lookup tables and formulas from the old spreadsheet into the new template. 00:09:40.900 --> 00:09:46.200 I would also recommend you watch the new Excel Pricing videos in Campus 00:09:46.200 --> 00:09:53.466 which describe the new product properties table in more detail so you fully understand the options and how they work 00:09:53.466 --> 00:09:57.666 before you start to set up your own pricing templates.