Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by cubicsquare

  1. Two gripes after a long absence from this forum: 1. My signature appears not to be updated. It's meant to state that l'm on the latest CubeCart version, and l think also the latest php version. 2. Suddenly the green dots of appreciation are missing and l'm just described as a rookie and other longstanding users are now mere newbs when in fact they've created large parts of CubeCart's functionality. Not good.
  2. OK so l guess l just install Cloudflare server-wide, rather than cart-by-cart. Thanks for the tip! I may already have Cloudflare installed, l'll check with my hosting service.
  3. Hi there, l've just checked the marketplace, and discovered a few likely solutions: £19.49 - https://www.cubecart.com/extensions/plugins/bulk-update-sale-prices-by-category £25.99 - https://www.cubecart.com/extensions/plugins/category-discounts-fixed-price-or-percentage £25.99 - https://www.cubecart.com/extensions/plugins/discount-price-tiers-plugin Hooray for Noodleman! *there's also at least one plugin for customer loyalty vouchers as you suggested
  4. Hi there, is there a way to get hotlink protection for my images, so that 1 million copycat websites cannot appear out of nowhere, each with their own versions of my ads, with links to my actual images on those copycat ads, thus draining my bandwidth, as well as offering inferior products using my pics?
  5. Hi there, any pointers to setting up a buy X get Y free promo in CubeCart? Preferably: Y = the cheapest of the selection, so for example: Buy 2 Get 1 Free means buy 3 items, and the cheapest 1 item is free of charge.
  6. @havenswift-hosting who said it did? EDIT: OK l realise l said it did. Well, i've decided it's no longer that important to me. I just wanted dual functionality, cat id and cat name, so that l could refer to categories by either, in case l ran into a shopping cart that insisted on cat ID rather than prosaic cat name.
  7. Ok i've decided to leave category IDs alone and let them do their thing. Seems odd that they are even displayed if they are not really user-oriented as such. Seems that they are more to do with internal machine talk.
  8. Sorry but your replies don't make sense to me. Thanks anyway.
  9. Hi there, when l delete all cats, the highest previous cat no. is not forgotten, and increment starts from there (that's the crux of my OP in fact). I know of no way to set auto increment back to 0. Please divulge.
  10. Hi there. I managed to delete the test category (realised l had to delete the product it contained too). In the process l had already created my own first category. Test category deleted. Own first category re-added. HOWEVER: its category ID was appearing as 3, despite no other categories in existence. I deleted it. Cleared cache. Created my own first category again. HOWEVER: it appeared with an ID of 4 this time. So it keeps increasing incrementally, with CubeCart for some reason never forgetting the deletion of previous categories inasmuch as their category number lives on, forever, and ever, and ever, and ever and ever. Is there a way to directly edit category ID? I have a set menu of categories. They MUST all have the same category number, across all carts that l am setting up.
  11. Hi there, l've written up a précis of the 1 July 2021 changes. There are still some weak areas, see wherever it states "ASSUMPTION(S)" in block caps. If there are any mistakes or ambiguities in my writeup, please point them out: ### To sell an item for under 150 EUR to the EU, with the new rules effective 1 July 2021: {BORING PART: - A single EU-wide distance selling VAT registration threshold of 10,000 EUR will apply and replace the country specific intra-EU distance selling thresholds. This means that if you make sales to non-VAT registered buyers in any EU countries, and the combined total of those sales exceeds EUR 10,000 (£8,818), you will need to collect VAT in all EU countries based on the delivery address. To do this you will either have to register for VAT in each of the EU countries where you make sales, or use the EU VAT One Stop Shop (not actually OSS if you are selling from UK to EU, instead it is called IOSS, Import One Stop Shop for us in the UK).} If the 10,000 EUR threshold doesn't apply i.e. if you are just an ordinary seller on eBay: - As a non-VAT registered seller, you would do nothing - As a VAT registered seller, you would still do nothing, except you will not charge VAT to your non-UK customers, but this is the same as ever - Alternatively, you could become VAT registered in the EU via the IOSS scheme (ASSUMPTIONS: presumably you can use OSS even if you are below the EU VAT registration threshold, and apparently you won't need to even be UK VAT registered). That is what it's for - it allows you to appoint a fiscal representative in the EU to submit your VAT returns to the EU (but you must still of course pay that VAT). - Some online marketplaces and even courier aggregator (courier comparison) sites allow the option to use their own OSS service, known as an "electronic interface". Otherwise you would have to find your own fiscal representative (this will need to be done if you run a shop from your own website for example). ### Benefit of the IOSS scheme: - You don't need to VAT register in each EU member state - Effectively streamlines customs clearance ("green channel" fast customs clearance for consignments not exceeding 150 EUR), and removes the customs clearance fee (this is fee levied by the courier for payment of import fees, whether you pay the courier those fees upfront to the courier or pay the courier those fees after clearance). - Makes you more competitive against other EU sellers ### Benefit of IOSS scheme over DDP: - There is no courier customs clearance fee ### Downsides of the IOSS scheme: - If registering yourself and not via a third party such as an online marketplace or courier aggregator website (i.e. not via a third party's "electronic interface"), the cost of appointing a fiscal representative can be £2,000-£8,000 per annum according to some quotes - Goods exceeding 150 EUR in value will exceed the IOSS threshold and therefore the import VAT will have to be paid to customs by those directly involved in the import (seller or buyer - via courier in either case) and not by a fiscal representative. This would be on a DDP or DDU basis. This could also trigger a regular VAT registration in the country of importation, if the seller wishes to sell the goods there - or to the rest of the EU. N O T E S : ### Note about DDU (now called DAP, "Delivered At Place" or DPU, "Delivered At Place Unloaded", with place of delivery specified e.g. DAP Amsterdam): the buyer must pay the customs clearance fee as well as all other import costs. ASSUMPTION: I believe this is also true of cargo shipments, not just retail to end user packages. ### Note about Simplified Customs Declaration (simultaneous to IOSS changes): To help importers and customs authorities cope with the ballooning volume of low-value consignments, the standard customs declaration for goods not exceeding 150 EUR is to be condensed. From July 2021, sellers will be able to provide a simplified declaration at the point of import into the EU via their courier service. This is a "super-reduced dataset" for the party declaring the import. The existing duties exemption for most goods not exceeding 150 EUR will remain in place.
  12. Hi there, just to echo my requests, in a more simple manner: I think all shopping carts would do well to get themselves an electronic interface for the seller to enable (should they wish): - DDP (Delivered Duty Paid - the electronic interface must give an accurate estimate of the end cost inc. import VAT and Duty for destination country, perhaps excluding the courier's customs clearance fee as that is down to the courier) - IOSS (Import One Stop Shop - for selling from UK to EU) - this is always bettern than DDP when both IOSS and DDP are possible i.e. goods sold for up to 150 EUR, because there is no customs clearance fee, so that removes a huge proportion of import costs for goods sold at less than 150 EUR. Currently all the basic seller can do is offer DDU (Delivered Duty Unpaid) (aka DAP - Delivered At Place), which may result in customer returns when faced with import costs from their country's customs.
  13. Thank you so much for your response. Al Brookbanks - please give us a CubeCart revision. Here is my suggestion for the bare minimum, having read Havenswift's response: 1. I think we can at least agree that country of origin and HS code can be added to the upload spreadsheet. Please, don't display HS code on the adverts though, or have a way of muting it if need be. The reason for having HS code and country of origin on the upload spreadsheet is that we have a record of how to tax the item if we decide to deliver duty paid. Also we will know how to fill in the customs slip for each item (e.g. if we are selling miscellanea). I think it might have other uses too, within our own country's taxation system e.g. if there is a tax inspection, we might need to know HS code and Country of Origin right off the bat. If you can implement this suggestion please may i know the column headings that you will use for HS Code and Country of Origin? 2. This is pushing the boat out a bit: i wonder if there's a way for CubeCart to deliver duty paid. That is, remit to the HMRC and / or the destination country's government the tax and / or duty due. I'm guessing the answer would be a flat "No" because it would be a job bigger than CubeCart itself. You'd have to link the trade tariff database with the seller's online tax account, and the seller might need a separate tax account for every country in the world. However, online marketplaces will probably all be doing this soon. eBay already is. I don't know if Amazon are yet but obviously it won't take long for them to catch up. This is the relevant page, it looks sort of like a DDP policy (delivered duty paid): https://www.amazon.co.uk/gp/help/customer/display.html?nodeId=G26L6NHEDGERVR8W That leaves shopping carts at a distinct disadvantage, because some sellers are reporting horror stories of international items being returned to sender when the true cost of the import becomes apparent. Customs in every country are now onto every parcel. Delivering Duty Paid at least leaves the prospective buyer with no surprises, even if it does more often than not put the buyer completely off. Edit: I think actually for request (2), it could be simplified if the final delivered cost is estimated (not collected, just estimated) upfront or at least during checkout. That way, no fancy electronic tax collection, and the customer is nonetheless absolutely aware of the final cost. Request (2) is therefore conceivably do-able, at least as a plugin.
  14. All carts have upsides and downsides but fun fact: WooCommerce was giving all my postage options as freepost - potentially disastrous (had to cancel my only ever sale because of that). Nobody knew what to do until a few months ago. Am still trying to get round to implementing their suggestion. For now, l'm back to testing testing testing (including CubeCart).
  15. Hi there, Please may l enquire how to adapt CubeCart to the new scenario. I'm not quite sure what is going on but apparently to sell to the UK, foreign sellers will need a UK tax remittance account. Surely sooner or later, the reverse will be true too? Does this affect CubeCart in any way? Also, is there a way CubeCart can cater for new situation with regard to: - GB EORI / XI (for selling to northern ireland from UK) - HS Codes for all items - Country of origin for all items - Either collecting and paying destination country's customs charges, or advising foreign buyers of the exact charges, or at least advising them that charges are likely, at checkout? - Keeping track of thresholds (e.g. going to EU, or entering UK) before customs pounce? I think some of this data may need to be part of the upload spreadsheet. If so, please may l know what the column headings will be named? I suspect personal shopping sites will face a battle against online marketplaces that take care of the mess upfront, at point of sale. I think shopping carts may need to find a way to connect with HS codes, and thereby give accurate breakdowns of customs charges, and even collect them upfront so that an item is delivered duty paid (DDP).
  16. hi there i can't recall much about this thread but i think i was thinking about the "All In One Shipping" tool, using weight categories as a vehicle for your different deals, e.g. classifying one club as a weight band, and for that weight band, you offer the deal suitable for that club.
  17. Hi there, l noticed that page had gone missing some time ago too. You really need to bring that page back. Add a donate button to your site. Add a subscription service - all plugins for one tier, all plugins + tech support for a higher tier etc. The job of a vanilla proof of concept shop should be unobstructed - bring back the import spreadsheet explanation table!
  18. cubicsquare

    New store

    I can't see it sorry!
  19. Hi there Al, l spoke with P2G and they say the don't support CubeCart any longer. For shame. Maybe you could pull a few strings and get them back onboard. I think it's best if l just manually input all my rates and update every 3 years. I shall now set about constructing a rate table. It'll certainly be more flexible than letting another company call the shots even if it's an aggregator. Just a lot of hard work that's all! But l've decided, once l have the rates in a spreadsheet, they might be transferrable. I shall now see if l can set them up via spreadsheet, to the "All in one shipping" extension instead.
  20. Provisionally: It would appear that Parcel2Go do not support CubeCart. Quite sad really. I shall try to ask Parcel2Go more about it in the daytime. Clearly they did once support it.
  21. Hi there, does anybody know how to make this work? It asks for an API key, how do l get the API key? Is the absence of an API key preventing the Parcel2Go shipping options from displaying? Currently l have nothing by way of shopping carts.
  22. Full disclosure: I haven't yet deployed my cart with shipping options or anything, just managed to get the inventory up that's all. Idea: secretly categorise different clubs as different parcel sizes? For each parcel size class, you can put in the actual weight of the item, and base your shipping costs on the weight alone. Just putting that out there ...
  23. Hi there, with that suggestion, l was saying: request total, because it won't be the calculated cost. It will be me offering a special unique deal to the person. It cuts out the need for programming the basket to automatically give multiple purchase deals and whatnot. Instead, l decide there and then what the total to pay shall be. Thank you for this information.
  24. Yeah those meta keywords were too ... er ... meta? Glad they're not necessary. Anyway dweeby is there any chance l can stay on topic and discuss the questions in my previous post? Shall l make a new thread? I guess l'm going off topic with the last few questions ...
  25. Hi guys. Thanks for the copious replies, l really appreciate it. I must confess l never knew this suggested URL existed: https://support.cubecart.com/Knowledgebase/Article/View/32/41/how-do-i-use-the-bulk-product-import-tool That URL basically answers my questions. Regarding meta keywords, l'm *G*L*A*D* l can give that a miss. It's so 2008, totally reaching for the ***t all that mindnumbing keyword stuff. However, if you do decide to completely phase the column out, l hope you explain why because newcomers like me will otherwise see it as something your software lacks. OK more posts forthcoming. But for now, back to the upload spreadsheet. I hope it doesn't fail lol! By the way, some things about the explanatory URL you showed me: 1. Erratum: Instead of "Document root relative path from the images/source folder. Before CSV import all images much have been uploaded to this folder" Why not: "Document root relative path from the images/source folder. Before CSV import all images will have been uploaded to this folder" 2. Also, an alternative explanation as l see it: Just give the filenames as they appear in your images/source folder (so, if you have a separate folder full of images for each item, and then put all of those folders into the images/source folder, include the entire filepath after images/source i.e. to upload three images of one of the many deckchairs you are selling, you might input: deckchair_orange/01.jpg,deckchair_orange/02.jpg,deckchair_orange/03.jpg,). Make sure to have all images uploaded before the CSV file of your inventory is uploaded. You may wish to use FTP if you have a lot of images to upload, especially if they exist in many separate folders. 3. Also quick question: will the images specified in the CSV be arranged in alphanum order of filename, or simply in the order in which they appear on the upload CSV file? 4. Some dude asked you a question at the bottom of that URL Quick followup question as promised: Can l specifiy a completely different route for the images, instead of "images/source"? I already have a very large amount of images on my allocated server space. They are used by my eBay adverts (inline, within the HTML). It would be horrible in many ways (effort, space, inelegant) to have to duplicate all the image folders and images therein, to CubeCart's "images/source" directory as part of my grand plan to copy my eBay inventory across to my website shop. Already at 30% of allocated quantity of files for my hosting plan with my provider. They say it's unlimited storage but they limit the no. of files l can store. Remaining questions for tonight: - Is there a way to make the Product Code private, so that it is displayed on all communication to me, but the online shoppers themselves never see it? Example: The Product Code might contain info about the first listing date of an item. That's not something l'd want shoppers to know. - Is it possible to add "Best Offer" to my listings, along with offer thresholds, and what to do with when the threshold is reached (instant accept, or allow to be forwarded to myself for consideration)? - Is it advisable to set up a Google category from the pulldown menu for each product? Or can l get equally far by sticking to my own bespoke categories? - Is it possible for buyers to request the total for a group of items in one basket? That's an approximate way of giving bulk buy / combined shipping to my buyers.
  • Create New...