Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


Posts posted by cubicsquare

  1. 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.

  2. 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 ...

  3. >>>> Ok thanks. I have solved it your way. When exporting to CSV, l have now selected: "Quote all text cells" and that has done the trick.


    >>>> That has also solved the "curious bug" mentioned in my previous post in red font.


    >>>> As for the "Condition" labels not appearing, please let it be known that the instructional table here: https://support.cubecart.com/Knowledgebase/Article/View/32/41/how-do-i-use-the-bulk-product-import-tool

    gives the example condition "New" with a capital N.

    Surprised nobody's caught that. I guess you have a huge untapped market there, for people that deal with bulk uploads i.e. people mirroring their eBay inventory? Because nobody has picked up on this flaw with bulk uploading via spreadsheeet and the example showing a capital N for New.


  4. Hello, unsure about "admin, Store Settings, Features tab, Sales Mode and Global Percentage Discount. " EDIT: You mean this to be a path.

    OK l checked, and Sales Mode was "Per product", Global percentage discount blank, number of sale items to display: 10.

    It makes not a whit of difference that l do the following:



    Let me explain: I downloaded the sample inventory. From that, l created an inventory upload template, based on a few hints here and there to fill in the blank columns.

    One of the fields was "Sale Price" which is not the same as "Price". Sale Price, you may recall, refers to the promo price.

    I left that blank, unfilled. CubeCart said "Oh hello, this means you want to give it all away for free!"

    Had l entered £0.00 in that column, CubeCart could legit say that, otherwise it had no right to assume.


    I've had to reupload everything (not too hard actually, somehow there must have been "memory" of my previous inventory). This time, l completely omitted the "Sale Price" column, just to be sure, though maybe if l included it, l could have just left it on "Ignore" when matching it up to the options on the pulldown menu in control panel. However, l still saw on intermittent "Sale" lists on the shop storefront, that all of my items were discounted to £0.00.

    I reuploaded the entire inventory, including the "Sale Price" column, but l selected to ignore it via the control panel pulldown menu. Still same problem. On intermittent "Sale" lists on the shop storefront, some - presumably all - of my items were discounted to £0.00.

    Moreover, there's no way to access the "Sale" and "Featured" and "Newly Listed" lists via the default shop template.


    I have now set the Sales Mode to "Disabled". Maybe it was remembering my very very very first upload, where l had a blank Sale Price column? And subsequent reuploads (having deleted entire inventory) did not un-forget that? I believe this has solved the problem.


    Curious bug: Meta Description column: if there's a semicolon in this column, the row in question gets shifted to the right thereafter, because whatever is after that semicolon goes into the next column along on that row.

    Another problem: Condition labels aren't displaying. I have most items set to "Used" but in the "Specification" window, the condition field is blank. Please can you help?

  5. Will it ever be possible to:

    - Tie in to an existing courier aggregator site e.g. Parcel2Go, at checkout?

    - So, the customer gets an applet representing a miniaturised version of the smorgasboard of couriers that Parcel2Go offers?

    - That way, customer chooses their own courier and tariff (unless YOU have said no to some couriers because they are physically nowhere near you for you to drop a parcel off with them, for example)

    - And of course YOU get to add a premium for the labour and packaging materials

    - Good thing is: full transparency with costs, and instant global reach without wondering if the grass is greener on the other side, because you're now no longer tied to one courier, you have many couriers to offer your customer


    - Note: l haven't yet set up my payments and couriers so maybe this is an irrelevant topic

  6. 14 hours ago, bsmither said:

    I would say it's your policy.

    ... not at all about how .... you want


    OK aside from that self contradiction, let me explain:


    - I was asking, not telling.

    - So, l wasn't telling that "this is my privacy policy, it's so cool isn't it" etc. etc. and then the response is "oh no it's not! That's not cool man"

    - I was asking: anybody got a privacy policy amenable to the situation described. Whether you like that situation or not.



    13 hours ago, Al Brookbanks said:

    Sadly there is no such thing as every organisation no matter the size is different.



    - I was asking: anybody got a privacy policy amenable to the situation described.



    Y'all try this:





    =IF(AND(ISTEXT($Q1,$A1),"Exact Response Goes Here",))




    Imagine if Excel started giving you jip?

    Good point about needing to be clued up on one's own privacy policy though, because one could get caught out by not reading one's own small print. So thanks for that, seriously.

  7. See the notes column for "Tax Class" row at https://support.cubecart.com/Knowledgebase/Article/View/32/41/how-do-i-use-the-bulk-product-import-tool

    Example given:

    tax_type Tax Class Number Tax Class ID


    No explanation as to what "2" means.

    Coming to think of it, the first row, "Status", is unexplained too. Just left at "1" by way of example. I'm guessing that means "online" or "live" or "visible" or "available", "0" being the opposite of all these synonyms.



    To rephrase my question: Tax Class ID is a number to be entered in the "Tax Class" column at the above link.

    What are the numbers? Who assigns / assigned the numbers? How?

  8. I'm guessing the GDPR thing about cookies is not in the same ballpark as a privacy policy for a small online business.


    Therefore, does anybody have a truly ready-made privacy policy. I will thoroughly read it through of course (box clever).

    I've seen a few on the web but they are still complicated.


    For example: If you are a sole trader, they expect your real name. And if you work from home, that means your home address.

    The problem there is: what if you don't want to give that type of info out?

    Ever spoken to a gentleman from you-know-where, on a Romanian country extension, who abruptly cuts out, then calls you again on another country's extension? And he wants to meet you in person? And other person from you-know-where also wants to meet you all of a sudden? It gets scary scary. I was only selling recycled plastic as well.

    Well, all l'm saying is, l'd rather not bare all, thank you. I'm happy giving an unregistered business name (l'm not a registered business as such, not registered for VAT anyway), and my storage premises for returns, a la eBay adverts.


    Is there a privacy policy for ME out there? A sole trader with a storage site that doesn't want to end up falling foul of international extortion rings that mistakenly think he has savings to speak of.


  9. Also:


    - You seem to demand a very narrow set of Condition labels e.g. New, Used.

    Turin shroud would be "Used" but that isn't really good enough. I'd like to formulate my own condition labels, or at least expand the available list of given labels to bring them in line with, say, the labels available on eBay, e.g. New, New - Other, Used, and *blank* for antiques.

    Personally l'd also add "New - Oldstock".

    - As for route to PCI compliance, l meant maybe recommend a 10-minute route to compliance e.g. use a PCI compliant payment provider and a dedicated PC, job done.

    - Please understand that at least one *MAJOR* online marketplace is widely thought to be constructively dismissing its bric a brac sellers in favour of global retailers, penalising them here and there because bric a brac is generally a nuisance so my point is: there is going to be a big influx of people looking to set up their own website shops to mirror their existing online marketplace shop. That paradigm isn't being much considered, l feel. Consider that most people will attempt to do it manually, rather than pay up front (or even merely trial) a cart 3rd party add-on that could, maybe, should do the job automatically, but it'd help to be a computer scientist to get the ball rolling etc. No ... most people will attempt to do it manually first off. So that's where l'm coming from. I want to manually mirror my online marketplace shop, by setting up a website shop using CubeCart or any other cart.


    I shall still perservere. I'd like to eventually submit a trip report for how l got it up and running, if indeed l ever succeed. Bye for now!

    • Like 1

  10. Quick question:

    In my own template upload spreadsheet, l see a column called "Short Description" which l am going to fill with the subheading of my existing online marketplace listings on another site.


    Title: SuperGadget Mk. II Limited Edition

    Subheading: Tested, this is way better than Mk. II for just a small premium extra. One small issue found with the battery compartment - see pictures.


    So, for "Short Description", l want to use the subheading as given above ^^^

    Good idea?

    Edit: i forgot to explain: I don't know how the "Short Description" column even made it into my upload spreadsheet. I had to construct the upload spreadsheet by hand so l may have been confused and added that column surreptitiously because l can't find it listed on the cheatsheet you linked to.

  11. Firm but polite criticism here: I see little consideration here for people that want to bulk upload an inventory, especially one that already exists on, say, an online marketplace. What l would have hoped for would be:

    - A template bulk upload spreadsheet, really this is essential. I guess this table, put into spreadsheet form, with guidance notes and all: https://support.cubecart.com/knowledgebase/article/View/32/41/how-do-i-use-the-bulk-product-import-tool

    - Privatisation of SKUs by default (but hey ... uploader can check box if he wants it visible on the actual advert), only to be made visible in system notifications (i.e. "Your item has sold - ship now" eMails) - because on my existing online marketplace, they don't reveal SKUs so l made the SKUs tell me when the item was first uploaded etc. etc. and l really don't want customers to see this type of info, it makes a product look bad if they see it's been available for 8 months with no buyers.

    - The spreadsheet would allow for multiple categories to be selected for a single inventory item

    - The spreadsheet would allow for one category to be the "main" category (although personally l don't care for this)

    - The spreadsheet would allow for image filepaths to be given for inventory items, with one of those images being the main image.

    - The image filepaths can point to stuff in any folder of your server, e.g. your existing images folder that you already use for your existing online marketplace inventory that you are trying to mirror on your own website

    - Any image size must be allowed. Too big for PHP to cope? I can't get my head around that but okay, then auto-resize, don't involve me in it, just make the software do it. Remember, if you already have an existing online marketplace, you have a zillion images already done. CubeCart is saying: "existing images? What existing images?" You know that sinking feeling when you realise a situation is pretty much untenable and out of your control?

    - A synopsis of PCI DSS compliance (user is no longer under eBay / Amazon's wing now, when setting up own website shop), not a curt knowledge base article. An idea: explain legal obligations for a small business online shop and give one suggestion for *quick* compliance for a small business online shop, which l'm guessing would be: * Separate computer for online business * Regular updated antivirus and firewall software & regular malware scans on the machine * Regular password changes esp. after a techie visits in person * Use a managed 3rd party payment provider, and what this actually means, plus example providers too, and how to ensure they are actually PCI compliant * How to obtain regular cart patches * Recommended business insurance companies and plans

    - Offer a free panoply of your own boutique security challenges that are required to authorise any changes to the online shop e.g. upload a photo as security key plus myriad other challenges (probably not gonna make a huge diff if online shop isn't actually handling payments themselves) * Show how to quickly rollback in event of disaster (l'm thinking manually restore a folder backup as the most simple solution, l just now noticed you also recommend a prog called Beyond Compare, and you also offer a paid cleanup service, good stuff) * Hide the identity of the cart brand if possible (probably not much use but l just thought it might be an extra layer)

    - Feature request subforum requires a separate account to be created? Serious? Too much bother.

  12. Regarding uploading inventory: I thought the downloadable inventory data was all of the inventory data, right?

    So, the upload data would have to match that, right?

    So, l thought l could make a spreadsheet for inventory upload that matches the columns in the download spreadsheet. Am l doing something very wrong here?

    Also, with my own product upload spreadsheet, how do l assign multiple product categories to one single item?




  13. 9 hours ago, bsmither said:

    Your spreadsheet would want to have at least these columns:

    cat_id, cat_name, cat_desc

    CubeCart will self-create a meta-title if missing. Other table columns have default values.


    Hi there, thank you for letting me know that CubeCart will self create a meta-title.

    May l ask:

    - How would l upload such a spreadsheet? I didn't think it was at all possible to even upload one.

    - l'm guessing cat_desc is meta-description?

    - I downloaded a bulk download spreadsheet showing only my test item. That spreadsheet was only an inventory spreadsheet, nothing to do with category uploads, BUT my point is: that spreadsheet had proper English headings for the columns (e.g. for "cat_id" as you call it, it has "Master Category ID"). So, at least for the category ID,  are "cat_id" and "Master Category ID" interchangeable? Of course it's no effort for me to write either but l'm just wondering why the difference in column headings for the same thing.



    Look forward to your reply

  14. Hi there,

    I wish there were a quicker way to add categories, rather than one by one. Some shops may have a large amount of categories, and the categories may be copy-pasteable directly from a parallel eBay shop (at least, via a text editor to format it ready for pasting directly into spreadsheet)

    I'm thinking: allow upload of a spreadsheet, where the headings are:

    ID --- Arrange --- Visible --- Status --- Category --- Name --- Meta Title --- Meta Description


    Finally: How important is it to have Meta Title and Meta Description for a category?



  15. Thank you.

    Another solution: use your current GPS as an authentication key in whatever security solution is used.

    That way, you can quickly know if you were hacked because hopefully you would know where you were at a given time. Problem then would be if the last given time and place were just erased.


    Maybe the malicious user will suss out your returns address is in a specific suburb of Bristol. OK so make sure never to authenticate GPS  from that suburb, and set it to reject any updates done where you secure the update by authenticating from your returns address's GPS or near.


    The list goes on and on. All about layers, l guess?!

    Anyway, please let me know of any useful Snapshotting tools e.g. Deep Freeze or whatever, i'd like links please?

  16. 10 minutes ago, bsmither said:

    There is a product, Deep Freeze, that works on a per-system basis.

    SQL Injection is a vector, not necessarily an end result. The end result is a polluted database that needs to be trashed and restored from backup.

    Can i have a link to Deep Freeeze?

    Also, do you think it's possible to completely erase mention of which cart you are actually using? (So that known exploits will still require a lot of legwork to find a website to use them on) Or would that take away  end customer's trust in the transaction? And / or could a malicious user suss it out anyhow?

  17. 4 minutes ago, havenswift-hosting said:

    There are multiple reasons for people wanting to gain access to websites, and especially those that take payments :

    1) Install keyloggers or other software to capture credit card transaction information

    2) Redirect payments, either full or partial away from the store owner to another source

    3) Redirect traffic to other websites

    Thanks, it all seems obvious now.

    I just thought a hacked cart would be a broken cart but evidently not so.



    So what do you think of my [obvious-as-hell] Snapshot button, as a means for counteracting these things?


    Obviously it'd be wholly or partly dependent on the use of a very long checksum

  18. OK i think i have an idea what it entails now. I just googled a specific cart software and what happened when it got hacked.

    I gather in a recent famous example (with another cart software), it's something to do with SQL databases being injected with code that steals card details.

    So, my next question, apart from further pending answers to the first question:

    Can't somebody create a Snapshot button so that when you're done uploading new inventory items, you press Snapshot, and that takes a snapshot of your entire shop's backend filing system, including the databases, so that anything new is rejected?


    The risk would be, l suppose:

    - Losing an entire inventory creation session because you forgot to Snapshot

    - Hacker snapshotting what they have added (but at least it'd be easier to roll back the changes. In fact, every day you might be able to roll back to your last inventory creation session, so that anything not legit in between then and now, gets rolled back)



    1 minute ago, bsmither said:

    "What exactly tends to go wrong?"

    Additional code gets added to the application. This added code can <insert your worse nightmare scenario here>.

    Thank you, just seen your reply

  • Create New...