Importing Product Fees from CSV

From version v3.7.0 onwards it is possible to set/update product fees using Magento's csv import functionality.

Example

The following Fees & Surcharges have been set up prior to executing the import.

Please note the Payment Surcharges have been set up using our separate Payment Surcharge extension.

Using the Import functionality available under System > Import choose Product import then upload your csv file.

Your csv file should contain at a minimum a sku column as well as a column fooman_productsurcharge_mods  when updating existing products.

The content of the column fooman_productsurcharge_mods  will get processed in the following manner:

1. The cell content will get split at each comma (,) to allow multiple fees and surcharges to be set per product
2. Each entry from step 1 is then split at the equal sign (=)
3. The first part references an existing Fee or Surcharge based on the description
4. The second part sets the amount for the product fee
5. To set a percentage add "Percent" in the third part like so "Tariff=10=Percent"

6. Optional when Product Fees is installed along side other Fooman Surcharge extensions additional product based calculation modes can be configured as the third part. The following entries are possible:

   - Exclude Product (excludes product from calculation when in default include mode)

   - Include Product (includes product from calculation when in default exclude mode)

   - Single item in cart cancels (item cancels the surcharge)

   - Only cancel if all items cancel (if all items in the cart cancel the surcharge is not applied)

In the below example csv file the following would happen

sku,fooman_productsurcharge_mods
product_1,Bulky Item Handling Fee=22
product_2,"Bulky Item Handling Fee=22.00,Setup Fee=33.49"
product_3,"Test=50,Payment Fee==Exclude Product"
product_3,"Tariff=10=Percent"

For product_1 the amount for the Bulky Item Handling Fee will be set to 22.00 (all currency amounts are in the base currency). Any pre-existing other product fees (Setup Fee) would be removed.

For product_2 the amount for the Bulky Item Handling Fee will be set to 22.00 and the Setup Fee to 33.49.

For product_3 the entry Test = 50 will get ignored as there is no pre-existing Fee or Surcharge with the description Test. This product will get excluded from the Payment Fee calculation.

For product_2 the amount for the Tariff Fee will be set to 10%