Jump to content

Nelly111s

Member
  • Content Count

    69
  • Joined

  • Last visited

Everything posted by Nelly111s

  1. I've wanted for a short while to export customer contact information into Google Contacts. From there, I can easily use the contact information in Quickbooks, my accounts package. I have cPanel access and using that and the phpMyAdmin, I went into the database and using the SQL below produced a query which I exported as a csv and imported without issue into. Google contacts. The SQL is below, should anyone wish to use it. I'm not a programmer etc - I learnt SQL ages ago briefly and it may be very crap code, but it works. Please don't ask me "how do I do this", "how do I modify to do this". I d
  2. OK, I'll send you a message with my email. Thanks
  3. Brian, I am willing to experiment. I have a "dummy" site on some shared webspace that I think I can use to try and see if it works. Thanks
  4. I want to be able to sell Gift Certificates that are redeemable against a specific item. I sell training courses as well as physical products and I want to create a Gift Certificate that could be bought for someone (eg as a present) and then redeemed for a training course on a given date to suit the recipient. Is this possible? I know I could ask the purchaser to buy a Gift Card for a specific amount, but this could then be used for goods as well as courses.
  5. I'd get in touch with the supplier of the plugin. I'm only a user, not a developer.
  6. I don't have a messages site, just a "normal" one selling stuff. I bought the plugin - it's really easy to use.
  7. I purchased the "Site Messages" plugin, which works just fine. I think it will be useful in future, so rather than hard code something onto a page, this seemed the best way forward. Thanks
  8. Cheers. Great help, as always. That'll be Thursday's job I think.
  9. I run a website which is staying open during the current crisis. I want to put a "banner" or something up so that anyone trying to buy stuff is aware of the fact that delivery may be impacted. I guess that a note on the checkout page may be the best? Has anyone either implemented something like this, or could give me a pointer as to which file(s) requires editing to effect something like this. Not sure if I want a "popup" or just hardcoded text. Thanks N
  10. Thankfully it didn't - it was only the GC. Seems to have worked ...
  11. I suppose they are really, but I would have liked to offer them all. Anything that makes a customer's life easier to purchase stuff is always a good thing! I'll give it a go when I have a few minutes (but I'm on holiday soon so it may be a few weeks) and report back.
  12. Thanks for that. I've cancelled the order (which should let the original purchaser know that it has been cancelled) and I've unchecked the status of the same Gift Card. I don't really like deleting orders when it's been cancelled - I prefer to have the record on file. As you say, the code is a bit "clunky" but its probably not a very usual occurrence, so hardly a big issue.
  13. I would like to cancel a Gift Card someone has ordered. He's got this as a present and can't get what he wants from me, so I'm going to refund him outside of Cubecart. If I cancel the original order in Cubecart, will it cancel the gift card so that it cannot be used in future? Thanks
  14. Thanks - I think I may install it and see if there's a sandbox version I can. have a look at. I have a copy of my site on another, dummy, server that I can have a play on. I know Braintree also did GooglePay and ApplePay (although they're still on my "ToDo" list). Do you know of any way of installing either of these on Cubecart? Thanks for the help
  15. Is there any "comparison" information between this and the "PayPal powered by Braintree" that I'm currently running?
  16. 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,
  17. 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
  18. I know this is a little old, but is the sitemap generator a freely available one, or bespoke and/or paid for?
  19. 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
  20. 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
  21. Thanks Dirty Butter - this is all really, really helpful info to me.
  22. 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.
  23. 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!
  24. Thanks, that's great. I'll try a couple of products tomorrow .
×
×
  • Create New...