Product Mash: How to use Macros with text fields in the product mash

Product Mash: How to use Macros with text fields in the product mash

Sometimes the default values, taken from Actinic, used by the Product Mash are not the best suited for your feed. Sometimes additional requirements of a feed mean that you need specific information from information already entered into Actinic.

Product Data Macros

List of Product Data Macros

Using more than one Macro at a time

File Content Macros

Custom Variables / User Defined Properties Macros

Product Option Macros

Product Data Macros - Custom Variables / User Defined Properties

You can use Custom Variables anywhere in your property definitions. You simply need to use a !!$ before and $!! after the custom variable to use. For example, to use a custom variable called EAN enter !!$EAN$!! in the field definition. Using this approach you can use more than 1 custom variable in a property definition. For example, to create a product description made up of some of 3 custom variables you have defined that contain the manufacturer, product type and product code you would use !!$Manufacturer$!! - !!$ProductType$!! (!!$EAN$!!).

You can use the following values in any of the feed fields to substitute information. Example of these are shown in the various feed examples.

!!ProductID!! The Actinic product ID
!!Link!! The Actinic item's product link
!!Title!! The Actinic product title
!!Description!! The Actinic product Description
!!Image!! The Actinic image URL
!!ProductImageNoPath!! The product image filename without any path information
!!SectionImage!! The image file for the parent section of the product
!!Price!! The Actinic product price
!!MinPrice!! The lowest price for a product
!!PriceForMinQty!! The price for the minimum quantity of products that can be purchased
!!CostPrice!! The cost price for the product
!!DeliveryCost!! The calculated delivery cost.
!!ExtendedInfo!! The extended info. text
!!Weight!! The product's weight (defined within Actinic)
!!SectionTitle!! Take the title text of the product's section. If you define your product's section with information that can be used in your feeds you can use this value.
!!ParentSectionTitle!! As above, but use the parent section of the section that the product is in.
!!ParentParentSectionTitle!! The same as !!SectionTitle!!, but use the parent's parent section of the section that the product is in.
!!SectionTree!! Use the section hierarchy (e.g. VIDEO->VHS->OLD.
!!ParentSectionTree!! Use the section hierarchy but do not include the parent section for the product (e.g. VIDEO->VHS
!!BarCode!! If you are using Actinic EPOS this uses the product barcode (EAN).
!!NumberInStock!! The number of items in stock (if using stock control)
!!InStockYesNo!! If the item is in stock use the value Yes, otherwise use No
!!InStock01!! If the item is in stock use the value 1, otherwise use 0
!!StockGt001!! 0 if the stock level is greater than 0, 1 otherwise
!!StockGt0YN!! Y if the stock level is greater than 0, N otherwise
!!StockGt001!! 0 if the stock level is greater than 0, 1 otherwise
!!StockGt0YesNo!! Yes if the stock level is greater than 0, No otherwise
!!StockGt0Text!! 'in stock' if the stock level is greater than 0, 'out of stock' otherwise
!!StockTextAbs!! 'in stock' if the stock level is greater than 0, 'out of stock' otherwise, the stock monitoring status of the product is ignored when this macro is used
!!StockYesNoAbs!! 'Yes' if the stock level is greater than 0, 'No' otherwise, the stock monitoring status of the product is ignored when this macro is used
!!ExtInfoImage!! The products extended information
!!ExtInfoImageOrImage!! The products extended information image or the product image if there is not extended information image
!!ParentProductID!! The main product ID for variant data
!!AltWeight!! The alternative weight for a product as defined in Sellerdeck
!!AltWeightIfDefined!! The alternative weight for a product as defined in Sellerdeck or if alt weight is not defined the standard weigh
!!InStockYN!! Sets to 'Y' if the product is in stock or does not have stock monitored, 'N' if the product is out of stock
!!InStockText!! Sets to 'in stock' if the product is in stock or does not have stock monitored, 'out of stock' if the product is out of stock
!!ExtendedInfoURL!! The URL for the extended image page
!!InfoLink!! The URL for the 'more info' page
!!AttributesShort!! The product attributes presented in a compact format
!!Attributest!! The product attributes
!!SppURL!! The URL for a products single product page
!!BrandFromTitle!!

Using the product's title extract the brand. This uses the following rules :
. Look for any text before a - (a minus sign). This is used in the field.
. If a - (minus sign) can't be found a tab character is looked for.
. If a tab character can't be found look for a space.
. If a space can't be found use the whole title text.

Even though this can be used for brand it can also be used for other fields.

!!OtherInfoPrompt!! The other info prompt for the product
!!DatePrompt!! The date prompt for the product


Using more than 1 Custom Variable in a product value

This is shown below:


File content Macros

If you want to put certain values, for example, your Ebay shipping Terms and Conditions, in a file you can include this file by using a !![ and ]!! around the file name. An example is shown below. This uses the value !!Description!! !![c:\Feeds\EbayFooter.html]!! to put a standard terms and conditions at the end of each product description.


Using custom property / user defined property values

If you want to include the value of custom properties from Sellerdeck in your feed you can use a macro to do this. �The format of the macro is :

!!$<filename>$!! eg !!$brand$!!

Make sure that you use the same case as Sellerdeck.

Including product option details

If you want to include the details of the options for a product in your feed you can use a macro to do this. There are two macros, one gives all the details on a single entry, the second creates an entry for each value.

To include all of the values for a product option within the same entry use !!#<optionname>#!! � eg !!#Colour#!!

To include all of the values for a product option in a seperate entry use !!%<optionname> � eg !!%Colour%!!

If you have used different names for the same option, you can enter a list with each name separated by the | character eg !!#Colour|Color|Shade#!!