Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


Posts posted by ayz1

  1. The desktop view should default to 4 products per row, are you viewing on a tablet? If so these changes will not have any affectas the number of products per row changes depending on the screen width.

    To change the desktop layout to 6 products per row change in file

    <ul class="small-block-grid-1 medium-block-grid-3 large-block-grid-4" data-equalizer>
    <ul class="small-block-grid-1 medium-block-grid-3 large-block-grid-6" data-equalizer>

    if you want to add extra products per row to a tablet screen size change the medium-block-grid-3 to medium-block-grid-4 hich will give 4 products per row.


  2. These attacks can happen to any website not just the well know website attacks that get into the news. One of my websites was hit and the attack continued for weeks. Hosting company said it was the biggest attack they had ever seen. If a website on a shared server is hit then every site on that server will be affected as the whole server will be brought down.

  3. Please backup your database or preferably test on a copy.

    Run this query once.

    ALTER TABLE ` shop1_ CubeCart_order_summary` ADD `time` DATE NULL;

    Then run these two queries each time (Change dates as appropriate)

    UPDATE ` shop1_ CubeCart_order_summary` SET `time`= FROM_UNIXTIME(`order_date`);

    SELECT order_date,
           shop1_ CubeCart_order_inventory.cart_order_id AS 'Order ID',
           first_name AS 'Name',
           last_name AS 'Surname',
           shop1_ CubeCart_order_inventory.name AS 'Product Name',
    FROM shop1_ CubeCart_order_summary
    INNER JOIN shop1_ CubeCart_order_inventory
    ON shop1_ CubeCart_order_inventory.cart_order_id = shop1_ CubeCart_order_summary.cart_order_id WHERE `time` BETWEEN '2016-01-24' AND '2016-01-25';

    I'm no expert so please test on a backup if possible.

  4. Just had another look at this and something like SELECT FROM_UNIXTIME(`order_date`) FROM `CubeCart_order_summary`; does convert the timestamps to date/time values so wondering if worth creating a new column and converting the timestamps to real dates to see if it is easier to work with.

    Just tried this and cretaed a new column called time and something like SELECT * FROM `CubeCart_order_summary` WHERE `time` BETWEEN '2016-02-17 11:25:10' AND '2016-02-18 11:25:10'; works.

  5. Looks like you need a WHERE clause in there e.g. WHERE `order_date` BETWEEN 1420070401 AND 1422576001

    I've been looking at something similar myself but because cubecart uses unix timestamps and not real dates to store the date information it's causing me a bit of a headache. Only way I've managed to get anything to work is to use the timestamps e.g. 1420070401  and  1422576001. You can create the timestamps at http://www.unixtimestamp.com

    There must be a way to use real dates but not found it yet. Hopefully someone with a bit more knowledge will be along with a better solution or a one that works if this isn't any help.






  6. 48 minutes ago, keat said:

    So I don't see the point in the email address in the ' Form submissions should be sent to ' field.

    That field is there so that standard form submissions can be sent to a different address than the store default (the one where order notifications are sent). If it is left blank the form submission will be sent to the store default email.

    If the section below is set up for individual departments then the email entered in the ' Form submissions should be sent to ' field. is ignored.

  7. I generated a sitemap of your website and there were no errors so looks like your website links are all OK. Might be worth finding out how the customers who have this issue get to the page e.g. is it directly from your website or from somewhere else e.g. Google or another search engine or a link from another website?

    Also have you upgraded from an earlier version recently e.g. V3 to V6?

    You don't appear to have a sitemap so that should be something to look into. You should have one.


  8. Foundation is fully responsive and free. It should also pass Googles test. You only have 2% using mobile but if yours is similar to the ours you may have a significant amount uisng a tablet. Foundation works well on a tablet. Maybe switch foundation on and do the Google test see what resuts you get.

  9. Well you can separate into several folders but that's going to be a pain. The above will remove the lag when doing general editing and the only time when there will be a lag problem is when changing images on a product because the pictures folder would have to be opened, however this is not done very often if at all once a product is listed.

  10. To speed up the page refresh when editing a product create a new folder in the images/source folder e.g. pictures then copy all of the files in the images/source folder into the new folder images/source/pictures (easy to do in cPanel) then run an sql query on the filemanager table to update the filepath to pictures/

    UPDATE `CubeCart_filemanager` SET `filepath` = "pictures/";

    Once all done delete the image files from the images/source folder.



  11. The mobile skin only seems to have two views large and small. It doesn't cater for tablets etc. Foundation is much better at resizing the screen to the appropriate size. With foundation on a tablet you get desktop view in landscape and mobile in portrait. With the mobile skin setting it loads the desktop layout into portrait view which is way too small to be usable.

  • Create New...