Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


Posts posted by cubicsquare

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

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

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

  4. 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?




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

  6. 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?



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

  8. 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?

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

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

  11. Hi there,

    I'm unable to leave suggestions in the suggestions forum, l'm unsure why. I'm being asked to create a new account. I feel l've created enough logins so far, really don't want to make yet another one for a forum l've already registered for!

    Here are my suggestions:

    - Must be 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 on the fly.
    - SKU should be made invisible to buyers, but visible to the seller in all eMails sent to the seller about any item
    - Must be possible to specifiy a completely different route for the images, instead of the cart's own dedicated images folder. 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).

    - And finally: allow people to post in the suggestions forum without having to make yet another account. Suggestions are your lifeblood!

  12. On 8/21/2019 at 9:31 PM, bsmither said:

    I don't understand how the "basket total" question is asking about anything different that an eCommerce app (including CubeCart) is supposed to do anyway.

    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.

    On 8/21/2019 at 9:39 PM, Dirty Butter said:

    It's SemperFi's AskAbout a Product plugin that makes it possible to let people Make an Offer if you choose that to be available. BUT that's all it does. It just provides a good way to identify exactly what they are asking about. Nothing automatic about the offer acceptance, counter offer, or rejection at all. And there seems to be a support issue on SemperFi's plugins which may not have been resolved - hope I'm wrong about that.


    Thank you for this information.

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


  14. Hi there,

    In order to check out the likely layout of any homemade bulk upload spreadsheet that l design, I bulk downloaded the default CubeCart inventory, the initial one with only one item on display.

    I have some outstanding questions, and l am now aware that some of them can be semi guessed-at by browsing the admin control panel (e.g. the tax stuff), but l still don't really have a clue, so here goes, please please please elaborate on all of the following columns if you can:



    Weight ---> Defaults to "4" which is a mere example weight for the default item on sale. HOWEVER: The bulk download spreadsheet doesn't have a column to specify units for weight! The specifications on the example advert referring to the example CubeCart stock item gives Kg, so that item is 4kg. Fair enough but is there any way to specify a different unit, e.g. grammes / g, rather than kg?
    Tax Class ---> Defaults to "1" but what does it mean?
    Tax Inclusive ---> Defaults to "0" which l guess means NOT INCLUDED? With "1" meaning INCLUDED?    
    Main Image ---> HEEEEEEELP!!!! How do l attach a title image to my listings via this column? Can l attach multiple images? Will they be displayed as a carousel of images?
    Master Category ID ---> HEEEEELP!!!! Defaults to "1". How do l use this? Does this relate to eBay shop categories? Can't l add subcategories too? And sub-sub-categories?
    Manufacturer ---> Can l leave this blank?
    UPC Code ---> Can l leave this blank?    
    EAN Code ---> Can l leave this blank?    
    JAN Code ---> Can l leave this blank?    
    ISBN Code ---> Can l leave this blank?    
    Brand ---> Can l leave this blank?    
    MPN Code ---> Can l leave this blank?    
    GTIN Code ---> Can l leave this blank?    
    Meta Title ---> Shall l make this a shortened version of my item title, such that it looks good a search engine results page (rather than Product Name on your shop advert)?
    Meta Description ---> I guess this would be the description as you'd want it to appear under the title on the search engine results page (rather than Short Description on your shop advert)?    
    Meta Keywords ---> HEEEEEEEELP!!!! I absolutely need a free tool to extract keywords from a spreadsheet column containing all of my advert descriptions, and to output the keywords as a parallel column. ANY SUGGESTIONS?    
    Condition --->    Defaults to "new". Are there a set range of terms l can use here? Or can l use my own special terms e.g. "New oldstock" "New - other" "For spares only"?
    Digital Path (Legacy) --->    Can l actually use this to specify a file location for digital downloads?
    Product Width ---> Can l leave this blank?    Will it cause problems if l add a courier shipping calculator tool to my basket?
    Product Height ---> Can l leave this blank?    Will it cause problems if l add a courier shipping calculator tool to my basket?    
    Product Depth ---> Can l leave this blank?    Will it cause problems if l add a courier shipping calculator tool to my basket?    
    Dimension Unit ---> Can l leave this blank? (It defaults to "cm") Will it cause problems if l add a courier shipping calculator tool to my basket?

  15. Hello,

    Please may l ask if CubeCart offers the following features, and how they can be implemented:
    - Give option of Guest purchases, i.e. purchases without a signup
    - Give option to reject all cookies, and still function as usual i.e. still allow customer to buy things
    - Add promotional rules to the cart (e.g. 5% discount if you purchase more than 1 item in one go, 10% discount if you purchase more than 5 items)
    - Add a promotional postage rule (e.g. buy 5 items together, postage to within the United Kingdom is free)
    - Add other postage rules e.g. postage to Scottish Islands requires an extra £1 surcharge

    - Also, please can you recommend an eBay listing import tool? I already have an eBay shop, and am aware that there is at least one tool for CubeCart that l can purchase as an add-on, but does it actually work? Can it completely copy your eBay shop, categories and all, to your new CubeCart shop? Can it sync your CubeCart shop to any changes in the eBay shop e.g. on your eBay shop: you manually delete an item or somebody purchase an item. I need this change to be instantly reflected in my CubeCart shop.
    - Can l even transfer my eBay auction items to my CubeCart shop? I mean, does CubeCart support auctions? If so, when somebody bids via my eBay shop, can l automatically close down the parallel auction on my CubeCart shop, provided nobody has already bid on the same item on the CubeCart shop?
    - Finally, is there a way to access the entire CubeCart shop as one file, so that l can search and delete the copious front- and end-matter of my eBay adverts when they are copied across to the CubeCart shop? The front- and end-matter references the same thing for each advert, and l would rather have it just stated once in my CubeCart shop's T&Cs area. Besides, some of the material references eBay-specific matters, so l really need to strip that away when the eBay ads are migrated to CubeCart.

    Please help in any way you can :)


  • Create New...