Jump to content

Nelly111s

Member
  • Content Count

    54
  • Joined

  • Last visited

Community Reputation

0 Neutral

Profile Information

  • Gender
    Male
  • Location
    Preston, UK

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  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)
×
×
  • Create New...