Jump to content

Nelly111s

Member
  • Content Count

    54
  • Joined

  • Last visited

Everything posted by Nelly111s

  1. Is there any "comparison" information between this and the "PayPal powered by Braintree" that I'm currently running?
  2. Thanks for the quick reply. And sorry for the slow response! I've solved the problem (mostly)! I used phpMyAdmin to run the following two queries. SELECT T1.cart_order_id, first_name, last_name, order_date, T2.product_code, T2.name, T2.quantity, T2.price, T2.tax_percent, T2.tax, ship_date, subtotal, total FROM CubeCart_order_summary T1 INNER JOIN CubeCart_order_inventory T2 ON T1.cart_order_id = T2.cart_order_id WHERE T1.id > '652' SELECT cart_order_id, first_name, last_name, order_date, ship_date, shipping, shipping_tax, shipping_tax_rate, total FROM CubeCart_order_summary WHERE id > '652' These two, when run can PhpMyAdmin can these be exported as csv files. When the two are combined in one file (Numbers or Excel) and exported as a csv, give me a file that can be imported to Quickbooks (I use QuickBooks Online (QBO)) which creates Sales Receipts in QBO. These Sales receipts have are numbered using the Cubecart order number, so it's easy to cross-refer the two. Ideally I'd like to "automate" this a little more so that I can run it from inside Cubecart and produce a csv automagically, rather than logging in to phpMyAdmin each time. My knowledge of php is thin, so this may, or may not, get done depending on it's complexity.
  3. I'm looking to "improve" on the Sales report, so that each sales record has the line items and cost of each line as well as all the current info. This is so that I can import the information into my accounts package (Quickbooks) and match it with the payment record. I'd like to be able to export the data as a csv file for upload. I've seen a few references to this with a quick search, but no example that I can see. Can anyone point me in the right direction? Thanks
  4. I know this is a little old, but is the sitemap generator a freely available one, or bespoke and/or paid for?
  5. Thanks, this helped a lot, but wasn't a 100% solution for what I required. I was trying to reduce all the prices (both retail and quantity discount) for a sale. If I just (manually) typed in a new sale price that was 10% less than the retail, this left the quantity discounts in some cases more than the sale price of the item. I then used the bulk price change to change (percentage by 90%) the quantity discount to reduce by 10%. If I tried to use the bulk price change on the sale price, this only worked if there was already a price in the "sale price" box on the product. I had hoped that the bulk price change may have been able to do the calculation "retail price x 90% = sale price". Since I only had to do a few items, it was no drama, but for more, it may have been a bit of a pain!
  6. I'm not sure how the "Per Product" sale item works, so forgive the perhaps simple question. I'm trying to reduce the price of 7 items in my store by 10% for a Sale. Most of the items already have quantity discounts which I also want to discount by 10%. Do I have to alter the sale price and the quantity pricing off each item, or can I somehow ask Cubecart to reduce all prices of these items by 10%? Thanks
  7. Thanks Dirty Butter - this is all really, really helpful info to me.
  8. To be honest, I'm not sure what else I need. I've been selling timber vita my store for a while (and the previous owner before me, too). I'm now selling training courses and wanted to make sure I gave my pages the best chance of been seen on Google, so that was the driving force behind me doing this. So I just want to start slowly with name, description, price etc. on some existing products and grow it from there.
  9. Thanks. Thats a great tip. Since I use a modification of foundation as a skin, it should be "easy" to do Do you know if you can do both things - i.e. microdata that is in the php (general) and microdata in each product? Not sure if I need that, or if it would make matters even worse!
  10. Thanks, that's great. I'll try a couple of products tomorrow .
  11. Thanks for this - a couple more questions though Where in the product content (in Cubecart) do I put the info (assuming it's microdata, not JSON). Is it in the "Search Engines" tab? What is a "call to action" file? I'm currently using the Google Structured Data Testing tool to test one of the products I'm trying to update, which seems helpful at first sight.
  12. I've got a little bit of time on my hands and thought that I would try and improve my SEO on my site. It's clear (to me at least, though I may be misguided) that I need some microdata on my products. I've got a couple of questions, very, very simple - I'm a Noob at this. Where, in cube cart, do I put the microdata information? Is it in the Meta Description box, or do I have to add to the source data view in the description? Can anyone point me in the direction of a good, startup tutorial? I've found this https://developers.google.com/search/docs/guides/intro-structured-data which seems like a good place to start, but is there a better way. I know that there's a HavenSwift module for this, but at present, I want to do this manually to understand what's going on.
  13. All the early entries (pre-March of this year, probably pre v6.1.14) have nothing (zls) in the column, Post that, they're all "NULL". I ran the query (with my prefix), the whole column had "NULL" in it. I then deleted the custom_oid index and recreated it with a UNIQUE key. Which worked. Hurrah - the database shows no errors/warnings now! Thank you so much for your help in resolving this. You've been very patient and helpful.
  14. These are the only indices listed for that table. I also tried to delete the custom_oid index (which worked) and then recreate it as Unique (which didn't work)
  15. I'm not sure if I've found something else that may or may not contribute to the issue. The image file manager is reporting the wrong values for filesizes. I updated all the images to make them smaller, but the file manager is still listing the old sizes, not the ones that my FTP client reports (which are the same as my cPanel filemanager.) Could this have contributed to the warnings in the error log (and do you know how to fix it)?
  16. As far as I can see, there are 51 entires in the CubeCart_order_summary table. There is only the custom_oid index and no entries with a numeric suffix. All names are listed on one page, with no option to scroll to another page.
  17. I deleted the custom_oid_2 originally (and 3 and 4), but it's not listed in the table at all now, so I don't know how to delete it!
  18. The admin_users table is now fine. Thank you. I deleted the cart_order_id_x indices and that worked fine. When I try and change the custom_oid index, I get this error #1062 - Duplicate entry 'NULL' for key 'custom_oid_2' The picture below shows that the index is already set at NULL (I think)
  19. Thanks. I’ll try in the morning. Any thoughts on why there are duplicate indices? I’m a little concerned my database isn’t in tip top condition.
  20. I've noticed a few errors in the Maintenance > Database tab. The errors are CubeCart_admin_users.admin_id has a key type KEY but expecting PRIMARY. This is listed in phpMyAdmin as both Primary and Index (Key). Should this just be Primary? CubeCart_order_summary.cart_order_id has a key type KEY but expecting UNIQUE KEY. When I try and change the index from key to unique, I get these warnings The indexes cart_order_id_2 and cart_order_id seem to be equal and one of them could possibly be removed. The indexes cart_order_id_2 and cart_order_id_4 seem to be equal and one of them could possibly be removed. The indexes cart_order_id_2 and cart_order_id_3 seem to be equal and one of them could possibly be removed. CubeCart_order_summary.custom_oid has a key type KEY but expecting UNIQUE KEY. When I try and change this, I get an error "#1062 - Duplicate entry "NULL" for key custom_old". I googled the error, but I'm none the wiser! The three below I fixed in phpMyAdmin CubeCart_reviews.approved has no key set. Expecting KEY. CubeCart_seo_urls.type has no key set. Expecting KEY. CubeCart_seo_urls.item_id has no key set. Expecting KEY.
  21. I've deleted all of the content and just left a couple of lines. I've not used that since July, so not sure how it's been corrupted. Do you know how it could have happened? The only thing I can think of is that I use Grammarly and they have recently altered their mode of operation within Safari and there was definitely a reference to them in the source code - bit of a long shot though But, the great news is that the settings now work OK. I can save both the new skin as a default and the social media links. Sorry if I shouldn't have posted the contents of the table - I assume if you could decode it that there was "sensitive" data in there? Thanks for your help - I've been at work (trying to make some products to put on the site!) I've still got a database problem though - I'll start a new thread for that, though.
  22. In the table the row with name "config" .(as per attached) has a large amount of text in the array. Here is the text in the array, when I use phpMyAdmin Thanks for confirming about the image sizes, but I needed to fix them anyway (and I've now got peace of mind that one problem has gone)
  23. I can't find any store setting that is big. I've only got a couple of sentences in the Search Engines and it's not been changed recently. Nor the Offline and Copyright tabs, both are very small. Is the config info written to the dB? Can I erase it and start again to see if it errors straight away? I looked in phpMyAdmin and in the Cubecart_Config table, the Config variable has masses of text in it. Other variables are small by comparison. Not sure if this is relevant. The config.xml for the foundation skin doesn't have the image reference line. I created my own skin (a copy of foundation with some colours changed, that's all) and that doesn't have the line either. The site is currently using foundation, but the site settings problem is preventing me from changing the skin anyway. I'll fix the folder names over the next day or so, but they've been like that for a year or more. I've just resized all my images (gulp!) to be 350Kb, 800px, but that doesn't seem to have fixed it either. Thanks for your continued help
  24. Error log is now more populated. See attached error_log
×
×
  • Create New...