CUSTOMVAR question

[TheInkDepot]

Hi all

I want to add a line of text in some of my product templates and wondered whether this could be acheived using customvars...i havent needed to use any upto this point so not sure what to do...all i want is to be able to do is add 'Buy One Get One FREE!' at the end of the porduct description...I tried simply adding the actual text to the template which dispalyed fine on site but when I carried out a test order the BOGOF line was missing from the sales emails and I need it to be there so i know to double the order quantity.

Many thanx in advance.

Boz

[NormanRouxel]

If you want info on the Sales Emails and Printed Reports you'll have to add it in to the Product Name as that's the only text that gets passed through.

Alternatively you could add a non-optional Component of zero price called e.g. BOGOF as that info is also passed through.

[TheInkDepot]

Hi Norman...we import our data from a excel file saved as a tab delimited txt file. In the excel file we have a number of columns one of which is called 'Short Description' it's a formula which pulls in the relevant info we want displayed in each product, it looks like this:

CONCATENATE(L166," ",H166," ",M166," for ",G166," replaces OEM ",F166)

I've tried adding 'Buy One Get One FREE' to the end but it doesnt show! I think it should be possible, I'm probably adding it wrong...any ideas?

Many thanx in advance!

Boz

[NormanRouxel]

Not my area. Best ask on an Excel Forum if no-one here can help.

[garyhay]

In excel to concatanate I just type

="A2&" "&B2&" a piece of text "&C2"

I remember having problems using the CONCATANATE function like you have.

[TheInkDepot]

yeh its weird...it just doesnt show 'Buy One Get One FREE' for some reason

Boz

[garyhay]

=a2&" "&b2&" Bogof"

[TheInkDepot]

Hi Gary

At the mo cells in our 'Short Description' column have this formula:
CONCATENATE(L166," ",H166," ",M166," for ",G166," replaces OEM ",F166)
which appears in the product description on our product pages like this:

Compatible BLACK Inkjet Cartridge for EPSON STYLUS C50 replaces OEM TO28

I want to add the 'Buy One Get One FREE' after the 'TO28' so that it is in Bold and gets passed over to the sales emails too. Wasnt quite sure want to do with the suggestion in your earlier reply.

Many thnx in advance

Boz

[Nadeem]

Hi there

The Product name field is limited to 80 characters, The product description is limited upto 255 characters. What does the formula do for the short description?

Kind Regards

[NormanRouxel]

The product description is limited upto 255 characters

I think it's more like 20K.

[TheInkDepot]

Hiya

The formula CONCATENATE(L166," ",H166," ",M166," for ",G166," replaces OEM ",F166) which appears in the product description on our product pages like this: 'Compatible BLACK Inkjet Cartridge for EPSON STYLUS C50 replaces OEM TO28' Click Here to see live example!

You will see 'Buy One Get One FREE' in the product description line after the OEM ref number BUT that is coded directly into the product template and doesnt get passed over to the sales emails which is what i'm trying to acheive.

Hope this makes sense

Boz

[cdicken]

Could you have a look at the tab-delimited import file (generated by Excel) and ensure that the 'Buy One Get one Free' text is in the import file. Try it without any HTML formatting (as this won't show up within the sales emails anyway).

If it is in the import file, then check it is appearing correctly within the 'Short Description' field of your products.

If it isn't in the import file, then maybe give us the formula from Excel that you are using for us to check.

[TheInkDepot]

Hi Chris...I checked the tab-delimited file and the 'Buy One Get One FREE!' text is in there but not showing when i preview the pages i've set up to test!

The exact formula i'm using is:
=CONCATENATE(L166," ",H166," ",M166," for ",G166," replaces OEM ",F166," Buy One Get One FREE")

its driving me nuts

Cheers

Boz

[cdicken]

Is it there in the application? Check the 'Short Description' fields.

[TheInkDepot]

Morning Chris

It wasnt in the application, so i decided to delete the 2 test bogof products from the catalog and import the text file in update mode...it DIDNT pull those products back in so I'm assuming there must be something in that code that is causing those products to be over looked.

Arghhhhhhhhhh

Boz