If there are a lot of products in your online store, it is often useful to make changes, for example, to prices or stock balances by making the same change to multiple products at the same time.

You can use MyCashflow's bulk edit tool or CSV tools for this purpose.

The bulk edit tool enables you to edit products and their variations directly in your online store's admin panel, whereas with CSV tools you can also create and edit other types of content, such as customers and campaign codes.

Bulk editing products in the admin panel

You can easily edit products and their variations directly in the admin panel by selecting the products that you'd like to edit from the list on the Products page and opening them in the bulk edit tool.

With the tool, you can easily filter the product information you want and set the same information (such as version visibility or tax rate) for all products being edited.

See also detailed instructions on bulk editing products.

Adding and editing data by using CSV tools

To add data to MyCashflow, simply import a CSV file with the saved data to your store. For example, by using a CSV file, you can define multiple products that will be created in your store after the file has been imported to the admin panel.

You can define the details to be added by using MyCashflow's CSV identifiers. For instance, each row in the CSV file to be imported can constitute a new product. The different columns in the row are then used for defining different product details, and the top of each column is labeled with an identifier that makes it clear what type of data the column contains. Below is an example of creating new products:
ProductName;     ProductVisibility;  ProductPrice;  ProductTaxRate;  ProductWeight;  ProductParcelType;       ProductCategoryNames;
Mittens;         1;                  14.95;         25.5;            0.2;            LETTER /Clothes/Gloves;
Winter mittens;  1;                  15.95;         25.5;            0.2;            LETTER;                  /Clothes/Gloves;
Fabric gloves;   1;                  5.95;          25.5;            0.1;            LETTER;                  /Clothes/Gloves

In the example, the following product details are defined:

  • Name (ProductName)
  • Visibility in the version selected in the admin panel (ProductVisibility)
  • Price (ProductPrice)
  • Tax rate (ProductTaxRate)
  • Product weight (ProductWeight)
  • Product categories (ProductCategoryNames)

See also a list of all available identifiers.

When you want to edit existing information, you need the ID numbers of the content being edited. For instance, if you'd like to edit 6 products, you'll need these products' ID numbers entered in the column ProductID of the CSV file. Based on the IDs, new data can be matched with the relevant products in your online store.

Once the import file has been prepared, save it in .csv format and upload it on the admin panel page Reports > CSV Import.

See also the detailed instructions on how to use CSV imports.