X-Cart forums

[shimmy]

Thanks for answering so quick. I have read it many times as I have done several template changes already but I just took another look at it anyway. I probably wasn't to clear about my question. What does it mean to "change" the line and then "replace" the line. It seems to me replacing the line will just undo the change

[Holub]

Ooops, I'm very sorry, I've really didnot understand you. I have made mistake in my that post ( copypasting is the evil!!!), so please excuse me. I've corrected mistake so please refer to my post http://forum.x-cart.com/showpost.php?p=247082&postcount=6

[shimmy]

Thanks for your patience, worked like a charm.

[Learner]

Originally Posted by Holub

You should modify /skin1/main/product_details.tpl

Find in this template (line about 281):

<option value='Y'{if $product.free_tax eq 'Y'} selected="selected"{/if}>{$lng.lbl_yes}</option>

and change it to

<option value='Y'{if $product.free_tax eq 'Y' || $product.productid eq ""} selected="selected"{/if}>{$lng.lbl_yes}</option>

This allow to assign free tax if new product being added.

Also with shipping, find line ( about 308 ):

<option value='Y'{if $product.free_shipping eq 'Y'} selected="selected"{/if}>{$lng.lbl_yes}</option>

and change it to

<option value='Y'{if $product.free_shipping eq 'Y' || $product.productid eq ""} selected="selected"{/if}>{$lng.lbl_yes}</option>

This allow to assign free shipping by default.

Thanks Holub for your fine modification of codes.But does this modification effects on already uploaded product on item card or necessary to save it again for individual product?
Please help me.
Thanks to all again.

[Holub]

You should execute this QL query via "Patch/Upgrade" admin interface:

update xcart_products set free_shipping='Y', free_tax='Y';

This query set free shipping and tax exempt for all products.

[Learner]

Originally Posted by Holub

You should execute this QL query via "Patch/Upgrade" admin interface:

update xcart_products set free_shipping='Y', free_tax='Y';

This query set free shipping and tax exempt for all products.

Thanks Holub for your response. Can you explain me the procedure of updating this (from admin panel or from phpmyadmin)? If from phpmyadmin in which table?
If from admin panel then exactly what to do? Please help me.

Thanks to all again.

[Holub]

If you use PHPMyAdmin, then you should open SQL tab at right panel, insert this query in field and press go. Table name is already in query, so you shouldn't worry about anything.

Via admin panel, open section "Patch/Upgrade", find dialog "Apply SQL patch" and past the query in the field "SQL query(ies):", and press "Apply"

[Learner]

Thanks Holub for your response.One question again.
If I want to activate free shipping ="yes"by modifying the codes and applying the patches from the admin panel for a certain period( four or five days) for all uploaded products,can I able to return from present states to original states that is free shipping="no" after this period by modifying codes and patches again to "no"?

Can you help me?

Thanks to all again.

[Amy]

I didn't have some of that stuff to change and have changed lots of stuff in x-cart so ended up letting it be for now

[Learner]

Originally Posted by Holub

If you use PHPMyAdmin, then you should open SQL tab at right panel, insert this query in field and press go. Table name is already in query, so you shouldn't worry about anything.

Via admin panel, open section "Patch/Upgrade", find dialog "Apply SQL patch" and past the query in the field "SQL query(ies):", and press "Apply"

Thanks Holub for your response.After modification from admin panel can I able to return from previous states that is free shipping="no" for all products by applying
update xcart_products set free_shipping='N'; Patch/Upgrade & and also modifying /skin1/main/product_details.tpl file?

Waiting for your response.

Thanks to all again.