Jump to content

 

Takestock

Member Since 08 Nov 2013
Offline Last Active Today, 06:30 AM
-----

#298221 Secondary Pictures Detailed Images

Posted by Takestock on 16 March 2018 - 08:17 PM

 

Hi guys.
 
My attention especially for Alan whose suggestion is interesting.
 
Alan, our hosting provider has recently changed our hosting solution with a cloud solution. Why not, ok .
 
But as you suggests, path for pictures isn't changed because it is relative. In order to look at the difference, using the export function is a good idea.
 
Ok. But I notice that other pictures, non depending from products, are also lost:
 
-the logo used in the invoice edition, the packing slip
-the barcode of the invoice and may be others images, less used, that I haven't still find out.  .
 
Where are they defined, in order to change their path with the new cloud server name ?

 

HI

I am quite confused by your question, It should not really matter what your cloud server is called, if your domain is www.mydomain.com then this should be pointed to /public_html

When importing publinc_html should not need to be part of the import path  as you are already working within the folder.

When export images the path is  exim/backup/images/

But to import image all you should need is the image name and of course product code.

 

In fact when you go into export the path for the image upload is show in one of the fields, you can change this if you want.

 

As for the logo on the packing slip ( it does not have one)

 

The invoice image can be uploaded by going to design/theme editor and logo, you can then right click on the logo on the front end and you will see it is in images/logos folder

 

The bar code on the invoice is not really an uploaded image is is produced on fly.

 

Like I suggested just setup a product in the way you want, export the images

 

go to export products,  use the images tab to do your export, set to comma delimited as this will open in excel

 

What you will see if you selected to export a single product with two image is to lines with the same product code

 

But the pair type will be different  (M) for main image  (A) for second image and subsequent images

 

LRP-101U-KIT A   exim/backup/images/6ae5cbc85c.jpg#{[en]:;} LRP-101U-KIT M   exim/backup/images/box_LRP-101U-KIT.jpg#{[en]:;}

 

to import all you should need is

Product code Pair type Detailed image LRP-101U-KIT A 5mp_stamp.png LRP-101U-KIT A 6ae5cbc85c.jpg LRP-101U-KIT M box_LRP-101U-KIT.jpg

 

Hope this helps

 

Alan




#291377 Change The Color Of Prices

Posted by Takestock on 16 December 2017 - 01:42 PM

Hi,

 

can you say me how can I change the color s of the sellingprices.

 

Regards

This may be what you are looking for otherwise you will have to find the css class and use custom css, you will find both option in

 

Designs/Themes/Theme editor ---  Customize colors or custom css.




#274698 Customer Specific Catalog?

Posted by Takestock on 07 April 2017 - 06:56 AM

Not sure that you mean. For example, you can create separate branch of categories which will be available to the specific user group only. So regular customers will see X menu items, customers with user group will see X+1 menu items

I think he is seeking to direct certain customers to spicific defined catalog when they login to the store. while still giveing them the ability to browes all other available cataloges. But with a link displayed which bring them back to there own uniquely defined catalog.

 

So sound like he is looking for a spicific redirect for each individual customer that logs in and a spicific dynamic URL for each as well.

Maybe webjive could clarify?

Alan




#272401 Cart-Power Add-On: Product Packages

Posted by Takestock on 07 March 2017 - 09:05 PM

Dear friends, 

 

The issue with the mobile version of the product package will be fixed this week. 

 

The issue with the Syntax error ha been fixed via our HelpDesk system.

 

Best regards,

Thank you for your excellent service

 

Alan




#242444 Theme For My Needs!

Posted by Takestock on 08 February 2016 - 06:55 PM

 

Note that I am new to CS Cart and I want the company to help if and when needed

 

As you are new to CS Cart, Please consider that it may not be the theme that is the issue, It may that you just need to gain a little bit of knowledge.

If you ask the questions here maybe someone will be able to give you the support you need.

 

Alan




#239803 Adding Image Name (Image Pair?) Formula With Open Office Or Ms Office

Posted by Takestock on 10 January 2016 - 10:10 PM

This will make it a lot easier. http://forum.cs-cart...images-alt-tag/

Yes this will make it simpler if you want the alt tag the same as the product image name. But that is not the question that was asked in this string.

He want to have the alt tags as a mix of the a game name and the system that the game runs on. I assumed that this would not be the same as the actual product name.

 

Alan




#217190 Speed Website

Posted by Takestock on 03 June 2015 - 10:12 PM

His site gets a B, C on GTMetrix. Not that great really. Or am I missing something?

my site gets a B , A on GTMetrix. But his site loads a lot faster on an actual browser. That's what really Matters.


#180177 Extremly Slow Sql Query When 120 000 Products

Posted by Takestock on 26 March 2014 - 07:02 AM

Hi all!


I have about 120 000 products across 9000 categories, with more then 800 000 references between them (each product belongs to 7 categories in average).

Latest CS-Cart (4.1.3 at the moment) runs on VPS with 4GB RAM, single-core configuration. Cache is stored in the database (mySQL with myISAM tables and mySQLi mode).

Memory_limit for PHP 5.5 is set for 2GB.

Every page takes about 5-10 seconds to load. Bottleneck is SQL queries, that sometimes take up to 30 seconds to build up their data.

For examples, there are such monsters as:

SELECT SQL_CALC_FOUND_ROWS products.*, descr1.product as product, MIN(IF(prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount)/100)) as price, GROUP_CONCAT(IF(products_categories.link_type = 'M', CONCAT(products_categories.category_id, 'M'), products_categories.category_id)) as category_ids, products_categories.position, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, IF(shared_descr.product_id IS NOT NULL, shared_descr.short_description, descr1.short_description) as short_description, IF(shared_descr.product_id IS NOT NULL, IF(shared_descr.short_description = '', shared_descr.full_description, ''), IF(descr1.short_description = '', descr1.full_description, '')) as full_description, IF(shared_descr.product_id IS NOT NULL, shared_descr.meta_keywords, descr1.meta_keywords) as meta_keywords, IF(shared_descr.product_id IS NOT NULL, shared_descr.meta_description, descr1.meta_description) as meta_description, IF(shared_descr.product_id IS NOT NULL, shared_descr.search_words, descr1.search_words) as search_words, IF(shared_descr.product_id IS NOT NULL, shared_descr.promo_text, descr1.promo_text) as promo_text, IF(shared_prices.product_id IS NOT NULL,MIN(IF(shared_prices.percentage_discount = 0, shared_prices.price, shared_prices.price - (shared_prices.price * shared_prices.percentage_discount)/100)),MIN(IF(prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount)/100))) as price, 100 - ((prices.price * 100) / list_price) AS sales_discount FROM cscart_products as products LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ru' LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') LEFT JOIN cscart_ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'ru' LEFT JOIN cscart_ult_product_prices as shared_prices ON shared_prices.product_id = products.product_id AND shared_prices.lower_limit = 1 AND shared_prices.usergroup_id IN (0, 0, 1) AND shared_prices.company_id = 1 WHERE 1 AND cscart_categories.company_id = 1 AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) GROUP BY products.product_id HAVING sales_discount > 0 ORDER BY sales_discount desc LIMIT 0, 8

Any advice how to handle such load?
I foresee, that these queries ate too complicated, and optimizing MySQL engine would not help much. Are there any other options to consider?

I am no expert in this, but with this number of products and categories even the best VPS with SSD and as much RAM as possible would be slow,

I would also suspect that storing the cache in the database would also be causing extra load on the SQL.

One thing that might help would be to turn on allow persistent sql connections. I took 3 seconds off my page load time on a 5000 product store on a VPS with about the same specs. but this will most likely come with it's own CPU load issue on a VPS of this spec an your 120 000 products

But with a store of this size only a dedicated server with as much CPU and RAM that you can throw at it will solve your issues.

Alan


#178804 Bunched Up Breadcrumbs On 4.0.3

Posted by Takestock on 05 March 2014 - 02:56 PM

Thanks Alan, the breadcrumbs are set to 12 width http://puu.sh/7jPoO.png

And here is a better view of the page with breadcrumbs - http://puu.sh/7jPpH.png

Hi ph
It's not that you breadcrumbs are bunched up. its that the product switcher contained in this <div class="product-switcher"> is covering your breadcrumbs. This should be able to be fixed with a bit of CSS.
but unfortunately this is not my strong point.

Alan


#178509 How Can I Cancel My Hosting Contract ?

Posted by Takestock on 28 February 2014 - 11:52 AM

This is not legal advice, but depending on which country you are in, but in most a contract is only worth the paper is written on. If its a case you are cancelling due to bad service then. Who is in breach of a contract if one exists.

My two cents worth is cancel your payment, send them an email informing them that you will be invoicing them €800 per item for any further correspondence to reply to any contact by them as (principle) or an agent (representative) Debt agency.
If they contact you further they are accepting the invoicing terms.

If they persist, send them an invoice. If they give your name to a debt agency. Follow them in the small claims court for payment of same.

Alan


#178278 Cs-Cart Is Now Forcing You To Pay For "searchanise" If You Want To Us...

Posted by Takestock on 26 February 2014 - 07:28 AM

Here is a perfect example of how BAD the default search is in CS-Cart. If you look at the following product on their website...
http://demo.cs-cart....hone-green.html
Now in the search box do a search for...
green cell
...and it will return and say no products found! The sad part is you just looked at a green cell phone but their search has been downgraded so low that it can no longer find it.

Hi Clips
While I an not defending or trying to say that the search in CS is very good.
I must point out that its not quite possible for the search to return a result using "green cell" as this string does not seem to be included anywhere in the product info.
If you do a search for cell or ce, green or gre, 32GB or 32, Iphone or ipho, iSight or Isig, iOS 7 etc your product is always returned in the results.

Its like asking a me a question in Russian, I don't speak Russian. So I need a little help..
If you want a result from Green Cell then you will need to put Green Cell somewhere in the product info.
Unfortunately I don't think CS Cart or any other search can read images, in this case even the image is not called Green Cell.

Alan


#173810 Changing My Account block links

Posted by Takestock on 20 December 2013 - 10:27 AM

HI Fishtail
If anything you have more chance of messing up your site by altering the original files. There are lots of posts which detail out using hooks. But none that I can find that give all the info.
But in simple terms, If you look at the .tpl files you will see a starting hook tag {hook name="profiles:my_account_menu"} and then code and then a closing hook tag {/hook}
What this means is that you can change this code, place something after the code or overwrite it completely from an external file using the my changes addon

You do not actually change the code directly within the .tpl you are diverting to your own file with the changes completed there.
But this is done automatically by the hook code, you do not have to alter the original file.

Here is a link to a tread that helped me a lot.
http://forum.cs-cart...__fromsearch__1

In your case you would copy the code

{hook name="profiles:my_account_menu"}
{if $auth.user_id}
{if $user_info.firstname || $user_info.lastname}
<li class="user-name">{$user_info.firstname} {$user_info.lastname}</li>
{else}
{if $settings.General.use_email_as_login == 'Y'}
<li class="user-name">{$user_info.email}</li>
{else}
<li class="user-name">{$user_info.user_login}</li>
{/if}
{/if}
<!--<li><a href="{"profiles.update"|fn_url}" rel="nofollow" class="underlined">{__("profile_details")}</a></li>-->
<li><a href="{"orders.downloads"|fn_url}" rel="nofollow" class="underlined">{__("downloads")}</a></li>
{elseif $user_data.firstname || $user_data.lastname}
<li class="user-name">{$user_data.firstname} {$user_data.lastname}</li>
{elseif $settings.General.use_email_as_login == 'Y' && $user_data.email}
<li class="user-name">{$user_data.email}</li>
{elseif $settings.General.use_email_as_login != 'Y' && $user_data.user_login}
<li class="user-name">{$user_data.user_login}</li>
{/if}
<li><a href="{"orders.search"|fn_url}" rel="nofollow" class="underlined">{__("orders")}</a></li>
{assign var="compared_products" value=""|fn_get_comparison_products}
<li><a href="{"product_features.compare"|fn_url}" rel="nofollow" class="underlined">{__("view_compare_list")}{if $compared_products} ({$compared_products|count}){/if}</a></li>
{/hook}

put it in a new file called my_account_menu.override.tpl and place it in a folder /design/themes/your template/templates/addons/my_changes/hooks/profiles

make your changes to the new file
<!--<li><a href="{"profiles.update"|fn_url}" rel="nofollow" class="underlined">{__("profile_details")}</a></li>-->

Save and clear the cache.

This is assuming you have setup the my changes addon.

On the other point I tried adding "disabled=disabled" in the input tag of this file for email:

No sure on this but try using True or False instead of disabled

Alan


#173748 Changing My Account block links

Posted by Takestock on 19 December 2013 - 07:27 AM

HI Fishtail
As per above by requincreative, to find the line of code go to design/ template editor/ templates/ blocks / my_account.tpl

Line 21 This is good for a quick fix but may get overwritten on next upgrade, The best way to do this is to use mychanges add on
do a hook of the lines of code that you want to change and then make your changes there.
Hook is from line 10 to 33

{hook name="profiles:my_account_menu"}
{if $auth.user_id}
{if $user_info.firstname || $user_info.lastname}
<li class="user-name">{$user_info.firstname} {$user_info.lastname}</li>
{else}
{if $settings.General.use_email_as_login == 'Y'}
<li class="user-name">{$user_info.email}</li>
{else}
<li class="user-name">{$user_info.user_login}</li>
{/if}
{/if}
<!--<li><a href="{"profiles.update"|fn_url}" rel="nofollow" class="underlined">{__("profile_details")}</a></li>-->
<li><a href="{"orders.downloads"|fn_url}" rel="nofollow" class="underlined">{__("downloads")}</a></li>
{elseif $user_data.firstname || $user_data.lastname}
<li class="user-name">{$user_data.firstname} {$user_data.lastname}</li>
{elseif $settings.General.use_email_as_login == 'Y' && $user_data.email}
<li class="user-name">{$user_data.email}</li>
{elseif $settings.General.use_email_as_login != 'Y' && $user_data.user_login}
<li class="user-name">{$user_data.user_login}</li>
{/if}
<li><a href="{"orders.search"|fn_url}" rel="nofollow" class="underlined">{__("orders")}</a></li>
{assign var="compared_products" value=""|fn_get_comparison_products}
<li><a href="{"product_features.compare"|fn_url}" rel="nofollow" class="underlined">{__("view_compare_list")}{if $compared_products} ({$compared_products|count}){/if}</a></li>
{/hook}

Loads of threads about hooks I am only learning myself.

To remove the bottom my profile link,
While in template editor / the dropdown beside the save changes button has a link, Onsite template editing.
you can go to the bottom account menu and delete the link there

Alan


#172224 importing subscriber e-mails via CSV

Posted by Takestock on 23 November 2013 - 07:21 PM

HI
It will depend on which version you are using, but in 4.0.3 it is quite simple to do this.

If you go to Administrator / export data / subscribers and do an export of the CSV with whatever delimited you want to use.

You can them use excel to open this. enter your email addresses and then save it as a CSV file. With whatever delimited you want.

Then just go to Administrator / import data / subscribers and import the file.

Just make sure you pick the delimited you used.

Some field are required email : mailing list: language:
It might be best for you to add at least one subscriber to the mailing list before export you can then auto fill the entry's to do the import.

Alan