Bulk Editing Products with .CSV Files
You are able to import or export any and all product data by either using the Quick Links on the Dashboard, or by navigating to Products > All Produts > Import, or Products > All Produts > Export from the admin panel.
Exporting Product Data
When you click Export you will be asked to configure your export. If you click Generate CSV, everything will be exported.
Otherwise, you can filter down what data you want to export – such as particular columns of data, particular product types, and products of particular categories.
Once exported, you can open the .CSV file and take a look at all the data that has been exported.
From here, you can start applying changes to the data if you wish to bulk update certain product data. Ensure that the ID and SKU fields are always included in product data spreadsheets. Also ensure that when you are ready to save the spreadsheet that you save it as a .CSV UTF-8 file. Other .CSV file formats will cause formatting issues and special characters will be replced with question marks.
Importing Product Data
When importing product data into the online store, there are two main methods: importing product data to create new products, or importing product data to update existing products. One import cannot perform both functions at the same time, so you will need to select which of the two you wish to do when importing a product data spreadsheet.
To import a spreadsheet, click Import on the Dashboard, or navigate to Products > All Products > Import.
Click Choose file and select the .CSV (saved in UTF-8 format) that you wish to import.
If you are importing new products, click Continue.
If you are updating existing products, tick the checkbox for Existing products that match by ID or SKU will be updated then click Continue.
One import cannot perform both functions – you must select to either update existing products or create new ones.
Once a Product Type is changed from Simple Product to Variable Product, the General section no longer shows the RRP or Sale price of the product. Pricing is now set per variation in the Variations tab.
Variable Product is a matrix item that defines a set of attributes for a product like colour and size, and then creates combinations of all attributes. Each combination is known as a Variation. The Variable Product has an SKU, and each variation has an SKU.
Products with Variations in MYOB are treated like a simple product. Each combination is its own Inventory ID. When creating variable/variation products here in the online store, each Variation SKU must match the corresponding MYOB Inventory ID.
There is no Variable Product SKU equivalent in MYOB that we use. Therefore, we need to make up a new SKU for the Variable Product.
A simple formula is to grab the first variation SKU and add “-parent” to the end. For example, SKU001-Parent would be the Variable SKU, while SKU001, SKU002 and SKU003 would each be Variation SKUs.
Select the Attributes tab, and under Custom product attribute, select an Attribute and click Add. More attributes can be created by navigating to Admin Panel > Products > Attributes. Currently there are three attributes to choose from: Brand, Colour, and Size.
Once you add an attribute, select which values of that attribute apply to the product. In this example, the product has three colours: Black, Blue and Coyote. To allow these attributes to be used for variations, tick the box next to Used for variations. Click Save attributes.
Add a second Product Attribute if required, select its values for this product and tick Used for variations. You can click Select all to add all attributes to the product.
You will notice that a Fee has appeared next to Variations. This is a feature we aren’t using, but there may be use cases in the future. It is possible to add additional costs to different attributes here.
Once you’ve added all the attributes for the product, navigate to the Variations tab. You can either add Variations one at a time by clicking Go next to Add variation, or you can Create variations from all attributes to do it all in one go. Once that is done, a message will pop-up letting you know how many variations were created.
We now have combinations of all attributes created as Variations.
Each variation can now be edited to have their own SKU code, price and image, among other options. Click the blue gallery icon to add a Variation image. When an end user selects this variation (combination of Colour Black and Size 3XL), the image uploaded will be displayed to the user.
It’s also possible for each variation to have its own gallery. This is most useful in the event that we have a sets of product images in different colours. To create a Variation Gallery, click Add Additional Images.
Ensure that the SKU you enter per variation matches up directly with a MYOB Inventory ID. To set the Stock status to an actual number instead of just “In Stock”, head to the Inventory tab and tick the box that says Manage stock?
Edit All Variations at Once
Given that there can be a significant amount of variations, you can save time by doing some “bulk editing” – editing values across all variations at the same time. To do this, click the Add Variation dropdown, and you can select a value to change for all variations, including Pricing and Inventory.
Set Default Form Values
When a user visits a Variation product, they will be presented with dropdown boxes to select their options – such as size and colour. By default, no options are selected when a user vists the variation product page. It is possible to set default values, so that when the user visits the page, size Large and colour Black, for example, are already selected. Set Default Form Values to enable this feature in the Variations tab of the Product Data table.