Jump to content

Eddy's Content

There have been 29 items by Eddy (Search limited from 03-Apr 19)



Sort by                Order  

#49664 Quick search - Exact words in Product name and Search words

Posted by Eddy on 08 June 2009 - 08:41 AM in Configuration

Hi All,

I'm configuring the new version of cs-cart 2.04 and I need the search in the quick search box

I want to find the "Exact" name of the item in "Product name" and "Search words" only.

Could anyone can help me?

In the advance, I don't find the feature search in front store "The feature of the product should be search able) as the version 1.35

Many thanks



#50204 How can I make search only show products with all words

Posted by Eddy on 17 June 2009 - 08:50 PM in General Questions

How to you do with Cs-cart 2.04?

I want to search exact in the Product name and the Search words only. I don't want it searches in short and full description.

Here are some adjust I made to search Exact in the Quick search and search by product code but it doesn't work well

---------------Original code----------------------
// Search string condition for SQL query
if (!empty($params['q'])) {

if ($params['match'] == 'any') {
$pieces = explode(' ', $params['q']);
$search_type = ' OR ';
} elseif ($params['match'] == 'all') {
$pieces = explode(' ', $params['q']);
$search_type = ' AND ';
} else {
$pieces = array($params['q']);
$search_type = '';
}

$_condition = array();
foreach ($pieces as $piece) {
$tmp = db_quote("(descr1.search_words LIKE ?l)", "%$piece%"); // check search words

if ($params['pname'] == 'Y') {
$tmp .= db_quote(" OR descr1.product LIKE ?l", "%$piece%");
}

-------------------Adjusted code--------------------------------------

// Search string condition for SQL query
if (!empty($params['q'])) {

if ($params['match'] == 'exact') {
$pieces = explode(' ', $params['q']);
$search_type = ' OR ';
} elseif ($params['match'] == 'all') {
$pieces = explode(' ', $params['q']);
$search_type = ' AND ';
} else {
$pieces = array($params['q']);
$search_type = '';
}

$_condition = array();
foreach ($pieces as $piece) {
$tmp = db_quote("(descr1.search_words LIKE ?l)", "%$piece%"); // check search words

if ($params['pname'] == 'Y') {
$tmp .= db_quote(" OR descr1.product LIKE ?l", "%$piece%");
}

if ($params['pname'] == 'Y') {
$tmp .= db_quote(" OR products.product_code LIKE ?s", "%$piece%");
}

Any one can help me?



#50310 moving to 2.0.4

Posted by Eddy on 18 June 2009 - 08:36 PM in Installation & Upgrade

I tried to export from v1.35sp4 to file and then import to cs 2.04
The name, description, meta... is ok but I cannot import the Images to cs2.04

Now my new shop (cs2.04) with full info but no product images

Does anyone have the experience or trick to do that?



#50315 How can I make search only show products with all words

Posted by Eddy on 18 June 2009 - 09:05 PM in General Questions

You should be looking in YOUR_SKIN/customer/common_templates/search.tpl. At the top of the page add/change the following red parts:

<form action="{$index_script}" name="search_form" method="get">
<input type="hidden" name="subcats" value="Y" />
<input type="hidden" name="type" value="extended" />
<input type="hidden" name="status" value="A" />
<input type="hidden" name="pshort" value="[COLOR="Red"]N[/COLOR]" />
<input type="hidden" name="pfull" value="[COLOR="Red"]N[/COLOR]" />
<input type="hidden" name="pname" value="Y" />
<input type="hidden" name="pkeywords" value="Y" />
[COLOR="Red"]<input type="hidden" name="match" value="exact" />[/COLOR]
{hook name="search:additional_fields"}{/hook} 


Many thanks baballuci. Many thanks

I tried and it works well for me.

But when I turn the Setting: Search also in Pages and Site News, it behaves stranged
The result is not perfect.

Any idea?



#50390 Label "New"

Posted by Eddy on 19 June 2009 - 06:51 PM in v1.x Store Design & Templates

I want default sort is added date for cs-cart 2.04

I mean, when I add the product to my store and it always display first (top of all others depends on the date)

Anyone can help?



#50393 Label "New"

Posted by Eddy on 19 June 2009 - 07:29 PM in v1.x Store Design & Templates

1. Add a language variable:

date_added = Newly listed

2. In "/include/common/search_products.php"

ADD THE PART IN RED BELOW

$sortings = array (
    'code' => 'products.product_code',
    'avail' => 'products.avail',
[COLOR=#ff0000]    'timestamp' => 'products.timestamp',[/COLOR]
    'product' => 'descr1.product',
    'position' => ($settings['General']['improved_product_search'] == 'Y') ? 'avail_products.position' : 'products_categories.position',
    'price' => 'prices.price',
    'list_price' => 'products.list_price',
    'weight' => 'products.weight',
    'amount' => 'products.amount'
);
3. In "/skins/CLIENT_SKIN/customer/product_pages/sorting.tpl"

ADD THE PART IN RED BELOW

<div align="right">
 <b>{$lang.sort_by}:</b>   
 [COLOR=red]<a class="underlined{if $sort_by == 'timestamp'}-bold{/if}" href="{$curl}&sort_by=product&amp;sort_order={if $sort_by == 'timestamp'}{$sort_order}{else}desc{/if}" {$onclick} rel="nofollow">{$lang.date_added}{if $sort_by == 'timestamp'}{if $sort_order == 'asc'}<img src="{$images_dir}/sort_desc.gif" width="13" height="7" border="0" alt="" style="margin-left: 5px;" />{else}<img src="{$images_dir}/sort_asc.gif" width="13" height="7" border="0" alt="" style="margin-left: 5px;" />{/if}{/if}</a>    [/COLOR]
 <a class="underlined{if $sort_by == 'product'}-bold{/if}" href="{$curl}&sort_by=product&amp;sort_order={if $sort_by == 'product'}{$sort_order}{else}asc{/if}" {$onclick} rel="nofollow">{$lang.product}{if $sort_by == 'product'}{if $sort_order == 'asc'}<img src="{$images_dir}/sort_desc.gif" width="13" height="7" border="0" alt="" style="margin-left: 5px;" />{else}<img src="{$images_dir}/sort_asc.gif" width="13" height="7" border="0" alt="" style="margin-left: 5px;" />{/if}{/if}</a>    
 <a class="underlined{if $sort_by == 'price'}-bold{/if}" href="{$curl}&sort_by=price&amp;sort_order={if $sort_by == 'price'}{$sort_order}{else}asc{/if}" {$onclick} rel="nofollow">{$lang.price}{if $sort_by == 'price'}{if $sort_order == 'asc'}<img src="{$images_dir}/sort_desc.gif" width="13" height="7" border="0" alt="" style="margin-left: 5px;" />{else}<img src="{$images_dir}/sort_asc.gif" width="13" height="7" border="0" alt="" style="margin-left: 5px;" />{/if}{/if}</a>    
 <a class="underlined{if $sort_by == 'position'}-bold{/if}" href="{$curl}&sort_by=position&amp;sort_order={if $sort_by == 'position'}{$sort_order}{else}asc{/if}" {$onclick} rel="nofollow">{$lang.default}</a>    
</div>


In the new version of CS 2.04, the sorting.tpl in /skins/your_skins/customer/views/products/components as follows:

<strong>{$lang.sort_by}:</strong>   
<a class="{if $search.sort_by == "product"}strong{/if} {$ajax_class}" rev="pagination_contents" href="{$curl}&sort_by=product&sort_order={if $search.sort_by == "product"}{$search.sort_order}{else}asc{/if}" rel="nofollow">{$lang.product}{if $search.sort_by == "product"} {if $search.sort_order == "asc"}<img src="{$images_dir}/icons/sort_desc.gif" width="7" height="6" border="0" alt="" />{else}<img src="{$images_dir}/icons/sort_asc.gif" width="7" height="6" border="0" alt="" />{/if}{/if}</a>    
<a class="{if $search.sort_by == "price"}strong{/if} {$ajax_class}" rev="pagination_contents" href="{$curl}&sort_by=price&sort_order={if $search.sort_by == "price"}{$search.sort_order}{else}asc{/if}" rel="nofollow">{$lang.price}{if $search.sort_by == "price"} {if $search.sort_order == "asc"}<img src="{$images_dir}/icons/sort_desc.gif" width="7" height="6" border="0" alt="" />{else}<img src="{$images_dir}/icons/sort_asc.gif" width="7" height="6" border="0" alt="" />{/if}{/if}</a>    
<a class="{if $search.sort_by == "position"}strong{/if} {$ajax_class}" rev="pagination_contents" href="{$curl}&sort_by=position&sort_order={if $search.sort_by == "position"}{$search.sort_order}{else}asc{/if}" rel="nofollow">{$lang.default}</a>    


How we can set sort default by added date (THe newly added will display on top?



#50396 Adding Product Code To Default Sorting

Posted by Eddy on 19 June 2009 - 07:53 PM in Hints & Modifications

This works for version 2 as well.



Dear Tool Outfitters,

How to do with the added date or time stamp?



#50498 moving to 2.0.4

Posted by Eddy on 22 June 2009 - 01:52 PM in Installation & Upgrade

Please read the instruction below carefully to proceed with upgrading your CS-Cart 1.3.5 .


Important note!

This script will update your CS-Cart v 1.3.5 sp4 up to CS-Cart v 2.0.4 and this will entail the following:

1) Addon settings will not be saved.

2) All modifications made on CS-Cart v 1.3.5 sp4 will not be transferred to CS-Cart v 2.0.

3) Not all Condition rules will be transferred from CS-Cart v 1.3.5 sp4 to CS-Cart v 2.0. Therefore promotions may intersect with each other.

4) There will be only those sideboxes specified in Listmania of CS-Cart v 1.3.5 sp4 and four more (Categories, My account, Mailing list, Information)

5) The "Basic" skin will be used for the admin panel and the skin defined during the installation of CS-Cart v 2.0 will be used for the storefront.

6) All images which were stored in the database will be transferred to the file system.

7) Manufacturers will be related to product features.

8) Topics will be moved to Pages.

9) Links in Top Quick Links will have the same values as before.



Upgrade steps.

1) Log in to the admin panel of CS-Cart version 1.3.5 sp4 which needs upgrading.

1.1) If it is specified in the settings that images are stored in the file system:
Ã*) Go to the "Settings" page (http://[YOUR-SHOP-CA...arget=settings).
b) Select the "Database" value for Images location.
c) Click "Update" to move images to the database.

2) Go to the "DB Backup/Restore" page (http://[YOUR-SHOP-CA...arget=database).

3) Specify the file name for dump - "dump_135_sp4.sql" and make the full dump of the database (all the tables) without any archivation.

4) Install the CS-Cart version NO LESS THAN 2.0.4 to a different web folder on your server.

5) Copy the following files to the root folder where CS-Cart version 2.0.4 is installed:
do_upgrade.php,
change_structure.sql,
update_descriptions.sql,
update_vars.sql.

6) Copy the CS-Cart 1.3.5 database dump created in point 3 of this instruction to the folder where CS-Cart version 2.0.4 is installed.

7) Launch the "do_upgrade.php" script.

After the "OK" text is displayed, the upgrade is considered complete and you can open the store. It is necessary to delete the following files after the upgrade is finished:
do_upgrade.php,
change_structure.sql,
update_descriptions.sql,
update_vars.sql.


Thank you for choosing CS-Cart


Where can I have the files:

do_upgrade.php,
change_structure.sql,
update_descriptions.sql,
update_vars.sql.



#50725 moving to 2.0.4

Posted by Eddy on 25 June 2009 - 08:43 PM in Installation & Upgrade

I tried to import but it doesn't seem ok

Wow, I have to re-upload all my pictures for the products.

Anyone can make Sort by: Default by the added date (Time stamp)

In the home page, I add the block for newest products and set Last days as 5 day but I think it doesn't work well

I don't know why?



#52648 Disappointed in 2.0.5

Posted by Eddy on 19 July 2009 - 05:24 PM in Configuration

I have the problem with blocks too,

Suddenly, all my blocks (Right, left and some in the center) are disappeared.
The first time when I used the version 2.04
And the second time is version 2.06

I think there is a big problem between the script and database



#53206 Cannot get past default order #

Posted by Eddy on 25 July 2009 - 04:25 AM in Issues & Troubleshooting

I have the same problem with placing order and database restore

Database error: Duplicate entry '16777215' for key 1 (1062)

The shop cannot run if placing order doesn't work



#53220 Cannot get past default order #

Posted by Eddy on 25 July 2009 - 10:08 AM in Issues & Troubleshooting

I found the problem:

16777215 (8 digit) is the limit of order number. If you set the "Initial order ID value" over 8 digits. It automatically number the order as 16777215, It reaches the final order of your shop.

TO fix this, you should delete the order # 16777215 in the Orders tab. Set "Initial order ID value" with less digits and it works.

Good luck!



#53242 File Editing with Excel

Posted by Eddy on 25 July 2009 - 07:38 PM in Issues & Troubleshooting

Edit "core/fn.fs.php" and replace


list ($field) = explode($d, trim($st, "\r\n"), 2);

with

list ($field) = explode($d, $st, 2);


THanks so many



#55274 Upgrading to 2.0.7 Error

Posted by Eddy on 25 August 2009 - 05:06 PM in Installation & Upgrade

I've got the message like this
Error
The upgrade package seems to be broken. Please try to download it again

I upgrade directly from Admin panel from my shop

And then I refresh and it did successfully!



#55285 My page always broken with the long title in Site News from ver. 1.34 and now...

Posted by Eddy on 25 August 2009 - 06:28 PM in Issues & Troubleshooting

I have to post my news to my site but all the designs of the page are broken if the Name of the news is longer then the space of one line.

Could you fix that?

Many thanks



#56769 Get ready for upragde to 2.0.8

Posted by Eddy on 15 September 2009 - 04:28 PM in General Questions

cant_find_config_parameter:config.http_host

What does it mean?
Now my shop is closed and the admin page cannot be accessed any more

What can I do with this error?



#56771 Get ready for upragde to 2.0.8

Posted by Eddy on 15 September 2009 - 04:36 PM in General Questions

Was upgrade completed fully?


No, I apply the update from my admin page for the live shop



#56782 Get ready for upragde to 2.0.8

Posted by Eddy on 15 September 2009 - 07:14 PM in General Questions

Can't change directory to install/: No such file or directory in /home/xxx/public_html/store/var/upgrade/upgrade_2.0.7-2.0.8.tgz/uc_override.php on line 861



#56783 Get ready for upragde to 2.0.8

Posted by Eddy on 15 September 2009 - 07:19 PM in General Questions

I opened the file uc_override.php and found the line 861 as follow

upgrade/upgrade_2.0.7-2.0.8.tgz/uc_override.php on line 861


861 if (ftp_chdir($ftp, $rel_path) && ftp_put($ftp, basename($source), $source, FTP_BINARY)) {
862 $ext = fn_get_file_ext($source);
863 @ftp_site($ftp, "CHMOD " . ((in_array($ext, array('tpl', 'css'))) ? '0777' : '0644') . " " . basename($source)); // set full permissions for templates and css files
864 $result = true;
865 ftp_chdir($ftp, $cdir);
866 }
867 }



#56847 Get ready for upragde to 2.0.8

Posted by Eddy on 16 September 2009 - 12:45 PM in General Questions

After the errors arise, I decide the install the fresh new one

This is my doing:

1. Back-up the database in 2.0.7
2. Make a new directory
3. Install the fresh new one 2.0.8
4. Copy the database from 2.0.7 to the directory var/database/backup/ of version 2.0.8
5. From admin page of 2.0.8, restore the database
6. Copy the whole directory Images from 2.0.7 over the Images of 2.0.8
7. Rename the directory 2.0.7 and 2.0.8 as you wish and adjust the config.local.php

Now you have the new 2.0.8 and the back-up shop of 2.0.7

Is it right? Do you think I have some wrong or mistake?

I don't know why, each time I do create the block Related product in Product tap in Design/Block. When I upgrade or my design block suddenly disappears, I recreate that block and the result I have so many Related products and Customers also bought in the product tap. See the attached screenshots

Attached Thumbnails

  • block many.JPG
  • block.JPG



#56854 Get ready for upragde to 2.0.8

Posted by Eddy on 16 September 2009 - 02:01 PM in General Questions

Eddy.
There are some files left in the old installation related to the blocks. Your method breaks the blocks.
I have no block issue with my method .

Kogi
Thanks. Apperently I missed out the update. Having updated , I have also opened the uc.sql, I saw two sql update line commands out of order. May be something to do with my editor !



2 Related products here is the result of last two upgrades (From 2.0.4 upgrade to 2.0.6 and 2.0.7)

Because each time I upgrade, it's gone in the block section. So I have to create the new one.

Is there any ways to delete them?



#56856 Get ready for upragde to 2.0.8

Posted by Eddy on 16 September 2009 - 02:24 PM in General Questions

I found that

If you put the block ID for xxxxx, you can delete them

http://www.your-cs-c...&block_id=xxxxx

But if I want it works, not hide. I don't know how to do because when I use the trick as above, I can edit that block but the error one and it doesn't display in block section

http://www.your-cs-c...osition=central

xxxxx=ID of block you want to edit or delete



#61052 Upgrade to 2.0.9 disappeared in my upgrade center

Posted by Eddy on 16 November 2009 - 01:20 PM in General Questions

Upgrade to 2.0.9 disappeared in my upgrade center
No more notice and upgrade package?
They have to fix the package or there's a problem with my store?
Anybody has the same problem like me?

Tks



#75238 2.0.13 is here!

Posted by Eddy on 22 March 2010 - 05:48 PM in General Questions

After Upgrading from 2.0.8 to 2.0.9-2.0.10-2.0.11-2.0.12 and now 2.0.13, all the SEO is not correct and it starts the new SEO

Some my Shipping methods are useless, It doesn't display to choose any more

Search Panel is disappeared

And this is the _ is thr prefix

* _rb_recurring_plans
* _rb_view_subscriptions
* _rb_subscription_events

How to deal with these errors?



#75241 2.0.13 is here!

Posted by Eddy on 22 March 2010 - 05:59 PM in General Questions

I did in Upgrade center panel

First, I close the shop and then choose the basic skin
Then Upgrade step by step in the Upgrade center with successful result
And I turn back to the old skin with 2.0.8. Quick search panel is disappeared.
Choose other skins, Quick search panel is ok but SEO, Shipping with big problems