Storegrab

Blog - Storegrab

  1. Securing Plesk 12 admin or higher with Lets Encrypt SSL

    How to secure Plesk 12 admin using Let's Encrypt

    For those unfamiliar with "Let's Encrypt" its an addon that comes integrated with newer versions of Plesk allowing one to encrypt any site and/ or subdomain with SSL for free. So of course lets start with taking the opportunity to secure your Plesk panel which should only take a few minutes if that.

    1) Log into Plesk. *

    If you're logging in under the IP address ie 123.123.133/etc you're doing it wrong. Instead choose the domain and port https://mydomain.com:8443

    Login to Plesk

    This should take you to your plesk login screen.

    2) Goto domain plesk is on.

    For 1and1 users it looks something like subdomain.onlinehome-server.com

    Securing Plesk

    3) Choose Let's Encrypt option

    Simply ad an email as requested and submit form. If all goes well you'll have a success message.

    4) Goto "tools & Settings > SSL/TLS Certificates"

    From here there should be an option asking which certificate to secure plesk, simply point it to certificate that was just created.

    Plesk SSL/TLS Certificates

    You're Done.

  2. Setting up Buyseasons with Storegrab

    How to setup your Buyseasons account to sync with Storegrab.com

    Getting started with Buyseasons integration is simple. This is a step by step instructional guide to help.

    1) Log into Storegrab App Website.

    Simply log into our Storegrab's secure application site with the username and password provided. The address is https://app.storegrab.com, to create an account with us simply purchase any of our software packages or give us a call.

    Login to Storegrab App Site

    2) Choose Vendors Category.

    From the left hand column menu please click on "Vendors > Overview".

    Vendors Options

    3) Choose Buyseasons from dropdown Menu.

    There should be a dropdown menu of the available Vendors including Buyseasons. Choosing Buyseasons and clicking on the submit button will now show your accounts Buyseasons status including basic recent pertaining data. If for whatever reason Buyseasons is not one of the available vendors list it either hasn't been setup or not purchased. If recently purchased please allow upto 24 hours to reflect on your account. To purchase Buyseasons please skip to section 3a).

    Choose Buyseasons from Vendors list

    3a) If not already purchased please choose to Add Buyseasons

    Please choose Buyseasons to add Buyseasons product integration to your account.

    Purchase Buyseasons

    4) Please insert Buyseasons account information

    Insert Username and FTP credentials to allow Storegrab to synchronize with your Buyseasons Direct account. This allows synchronization with product details, quantities, and even orders through their FTP. Before Buyseasons allows you to actually post orders you need to setup a few test orders and talk with a representative from Buyseasons. We're more than happy to take you through this process and double check that the XML format required is working.

    Setting for Buyseasons

    5) Choose Taxonomy

    Under Vendors > Taxonomy there is a simple and incredibly useful taxonomy tool to allow you to match buyseasons categories with your categories. The first column is your websites Categories, the second column is for Buyseasons. This tool will allow you to choose where Buyseasons products will appear on your website. You can sync to multiple categories and/ or choose parents and children categories.

    Taxonomy for Buyseasons

    6) Choose Schedule

    Under "Vendors > Schedule" you can simply choose when the Buyseasons feed will update. You can choose certain days and hourly intervals. There are two seperate sections here the top one will adjust the time(s) for the catalog which includes everything from descriptions and in depth product information. The second is for quantity updates.

    Schedule for Buyseasons

    7) Adjust Pricing

    Under Vendors > Schedule you can simply choose when the Buyseasons feed will update. You can choose certain days and hourly intervals. There are two seperate sections here the top one will adjust the time(s) for the catalog which includes everything from descriptions and in depth product information. The second is for quantity updates.

    Schedule for Buyseasons

  3. Magento to Buyseasons

    Integrate Buyseasons aka buyseasonsdirect datafeed directly into your Magento store. Automatically update inventory several times daily, remove outdated products and integrate new items.

    Buyseasons is a large online wholeseller and drop shipper that has approximately 20,000 products at any given moment mostly pertaining to costumes and novelty products.

    With a Magento store allow us to fully integrate their product feed directly into your database including everyrhing form Images to size charts and match those to your specific categories.

    • Full Buyseasons Catalog integration with all products imported into your online Magento storefront. Approximately 20,000 products at any given time
    • Full Buyseasons Details will also be integrated from pictures to descriptions and Sizing Charts. Videos and multiple imagesalso available on select products.
    • Attributes for sizing will be integrated on the fly into your Magento catalog. This means for example Small, Medium, and Large costumes would appear on one page with a dropdown for sizing choice
    • Order integration that is updated every 15 minutes seemlessly sending order information to Buyseasons and when orders are shipped retrieve said orders with tracking information. (EXTRA: Also send information to 3rd party sites if applicable)
    • Quantities updated hourly with buffering available of your choice. For example if 5 costumes are available you can choose to only show a quantity of 3... 20 items at 15 in stock...etc
  4. Restoring mysql from the command line

    Restoring mysql from the command line

    If you’re restoring a database from a file that’s over a few megabytes in data uploading the file directly to Mysql can stall. You can zip or tarball the file which may solve this however at some point you really just need to do the restore from the command line which is simple enough;

    mysql -u username -pdatabase_name < /path/to/file/file.sql

    Note: No space between the -p and password. ie: -ppassword

  5. Doba

    Doba is a middleman company that offers an amazing assortment of products ( over two million and over an amazing array of categories) and will either wholesale or drop ship to you or directly to your customers. The technical and customer service support is unparalleled in the industry and the software is completely user friendly. The only downside is that Doba is a complete and utter waste of time and money with the absolute minimum cost yearly of about $700 dollars and the actual cost provided on products at least that we have compared (and yes we have) are certainly not wholesale prices .

    We've all heard of snake oil salesmen and flim flam artist and the like. Doba is not a scam but certainly a company that is not setup to make any of their clients profitable in contrast to other wholesellers and drop shippers. They have aligned themselves up as a middleman to multiple distributers and offer to basically dropship your orders offerring the software and service for a fee of $59.95 a month Minimum.

    Lets Lay out the basic Pros and Cons to Doba...

    Pros:

    • All Products
    • All Details
    • All Attributes
    • XML Orders
    • XML Quantities
    • Boasts over 2 million products available
    • Top notch Customer support
    • Software and integration including custom API integration
    • Simple and professional site to use
    • Amazon export files ready to go

    Cons:

    • Fees are preposterous
    • The overwhelming amount of products we have researched are not at wholesale levels.

    Summary:

    This is one to avoid at all costs. It's a complete waste of time and resources in our humble opinion. This opinion has been vetted by many customers and documented thoroughly around the web with a quick Google search of "doba scam" being all that one would need. Quite simply if they offered real wholesale prices this may actually work, but quickly look at price list from DandH or Ingram Micro whom are two of the largest electronics distributors in the United stated in contrast to what Doba is offering to realize it's padding the numbers and charging you monthly to boot.

  6. Magento 2 on Linux with Plesk

    Manually adding Magento 2 to 1and1 Linux box with Plesk

    Added a Magento 2.0 template from Templatemonster of all places and ran into substantial problems even after making sure we were in full compliance with Magento 2’s prerequisites. If your planning on this venture there are a few things you need to know.

    Basics for Magento 2

    • MySql 5.6+ or greater
    • PHP 5.6.+ but NOT some of the 7+ packages so be cautious

    Link for Magento official prerequisites: Here

    These are for the basics for specifics please go to Magentos requirement page. If it caught you by suprise that some later packages as of this date are not compatable you’re certainly not alone. As we delve into this it becomes increasingly more resemblant of a beta and not a full fledged final software package.

    So lets take the template from templatemonster which is free btw.

    F2 – Free Magento 2.0 Theme Link: Here

    You have to register, but it is indeed a free fully responsive Magento 2.0 theme also includes pictures and products with categories to boot.

    • Download template
    • Unzip
    • Take fullpackage.zip and upload to root through an FTP clien
    • Use ssh to Login to linux and goto root as well

    Code:
    unzip fullpackage.zip

    • Go to your website in any browser and you should see a magento setup page welcoming you. If not you may have to check permissions and prerequisites.
    • Upload the added sources folder from the magento template. This will be on he unzipped template folder on your PC.

    ie: template_57559_mWq2X3gXn09q8E0zG7wv > sources_M67V82A7B6 > sources > sample_data

    • Upload the whole Pub folder to root and yes overwrite what’s there, should not replace anything just adding to images to template for sample data.
    • Same ‘sample_data’ folder there is a dump.sql file. We need to add this to the database BEFORE installing Magento.
    • Back to browser and install Magento

    At this point you can goto your admin or homepage assumming the install was a sucess and you’ll quickly realize that there’s something wrong as the stylesheets and images are just not there. This is of course due to permissions and yes an out of the box solution of the new and improved Magento is well showing immidiate flaws. Moving on to fix this.

    • Login via ssh and goto root folder where magento is
    • Change file permissions

    chown -R (NAME OF OWNER) /(YOUR FULL PATH TO ROOT)/
    find . -type f -exec chmod 644 {} \;
    find . -type d -exec chmod 755 {} \;
    find ./var -type d -exec chmod 777 {} \;
    find ./pub/media -type d -exec chmod 777 {} \;
    find ./pub/static -type d -exec chmod 777 {} \;
    chmod 777 ./app/etc
    chmod 644 ./app/etc/*.xml

    Still Fubar? Try this again.
    find . -type d -exec chmod 755 {} \;

    To explain essentially we need directories and files

    1. Under ownership of user thus the chown
    2. All files with permissions of 644
    3. All directories with permissions of 755
    4. In the Var folder all directories permissions of 777
    5. In the Pub/Media folder all directories permissions of 777
    6. In the Pub/Static folder all directories permissions of 777
    7. If for whatever reason more permissions (which makes no sense) doesn’t work try making it 755. Yeah I know, but lets just move on.

    Ok lets login to the admin. That menu not working? Some of the javascript not allowing you to manuver? Yeah … not file permissions just Magento. Sure there are fixes but lets just go ahead and upgrade regardless as these issues which btw are far from minor and should not even be in a beta package much less a full fledged release. (Yes this article shouldn’t be necessary nor exist but it is what it is.)

    Still in ssh? great, Let’s do this (btw, the first line is for version 2.1.7 obviously can be any version, as of writing this 2.1.7 was the latest)

    PLEASE NOTE: For whatever reason had do update to 2.1.6 first then to 2.1.7 , not sure as to why and wasn’t going to delve too far into a Magento upgrade glitch.

    • composer require magento/product-community-edition 2.1.7 --no-update
    • composer update --ignore-platform-reqs
    • (PATH TO PHP)/bin/php (PATH TO MAGENTO)/bin/magento setup:upgrade
    • (PATH TO PHP)/bin/php -d set_time_limit=3600 -d memory_limit=1024M /(PATH TO MAGENTO FOLDER)/bin/magento setup:di:compile

    Flush the cash
    (PATH TO PHP)/bin/php (PATH TO MAGENTO)/bin/magento cache:flush

    Reindex. just for good measure
    (PATH TO PHP)/bin/php /var/www/vhosts/(PATH TO MAGENTO FOLDER)/bin/magento indexer:reindex

    Now if you log into the admin panel of Magento you should immediately see the magento version in the bottom right. As of 2.1.6 it looks like all of the basics are indeed working. Here’s a working example of the magento 2 now 2.1.7 with templatemonster F2 template. Here

    Couple problems you May run into at least we did;
    Problem:
    "Warning: is_dir(): open_basedir restriction in effect. File(/etc/pki/tls/certs) is not within the allowed path(s):
    Solution:
    (PATH TO MAGENTO FOLDER)/composer.json
    This:

     "config": { "use-include-path": true }, 

    To this:

     "config": { "use-include-path": true, "disable-tls": true }, 

    Problem:
    Compilation was started.
    Repositories code generation... 1/7 [====>-----------------------] 14% 1 sec 46.0 MiBPHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 94208 bytes) in (PATH TO MAGENTO)/vendor/zendframework/zend-code/src/Scanner/FileScanner.php on line 36

    Solution:
    When compiling as was noted above add right after calling PHP;
    -d set_time_limit=3600 -d memory_limit=1024M

    Problem:

     Uncaught Error: Call to undefined method Magento\Store\Model\ResourceModel\Store\Interceptor::___init() in (PATH TO MAGENTO)/var/generation/Magento/Store/Model/ResourceModel/Store/Interceptor.php:13
    

    Solution:
    Shoot for a lesser version of Magento. In our case had to do 2.1.6 then 2.1.7

  7. Pricefalls Marketplace Integrations

    Pricefalls Marketplace is a relatively new and somewhat overlooked 3rd party catalog style marketplace where online retailers can list their products. Although it is fairly straight forward with a $19.99 dollar fee monthly and then a percentage of every sale much like the Amazon system we can happily say that this marketplace is indeed different than some others so not a complete "cookie cutter" approach as it were. For those looking into the catalog formula and maybe less and less into the cost per click advertising platforms available this really does appear to have a fully self contained shopping environment such as Amazon where the customer completes the entire transaction from beginning to end through the Pricefalls marketplace website however the actual payment goes directly and immediately to the retailer. Side note: Seems to date that fees are NOT taken out until monthly bill arrives from Pricefalls team. Lets Lay out the basic Pros and Cons to Pricefalls...

    Pros:

    • Paypal Integration / Instant Payyment
    • Authorize.net / Instant Payment
    • Fast Quality Design
    • Excellent state based customer support
    • Simple Menu system / Easy to use

    Cons:

    • Fees are just to high to warrant a monthly fee Traffic

    Summary: Overall certainly worthwhile if you are looking for another 3rd party catalog to advertise on. The traffic is enough to look into this one. Like us to integrate Pricefalls into your online store?: Pricefalls Integration

  8. Amazon Asins from UPCs

    ASIN stands for "Amazon Standard Identification Number" and acts very much like a UPC except that it is unique to Amazon and not unique to an actual product but really is unique to an actual Amazon AD. This is a crucial difference and one of the most overlooked opportunities on Amazon. Let 's just break it down simply. Lets say we have a particular toaster oven. It will have a UPC that is a unique identifier to that actual toaster. If you goto multiple appliance stores and look at that same toaster as you're shopping around the prices and description from multiple stores may vary however the UPC should still be unique. Now an ASIN is for the ad and not the product. This is the equivalent of going store to store and there is the same price, same description, and yes the same product. The ASIN is generated by an Amazon seller for a particular product. There are in many cases if not most multiple ASINS per UPC. Yes this means that for that toaster oven there maybe 5 or 6 different ads for the same product in the Amazon catalog. Confusing, maybe however it's a huge opportunity for sellers. If you're selling this said toaster oven and you upload an ad to Amazon tha's great and you're in the catalog, but please keep in mind there are 5 other ads already. The goal is to be on all of those ads as well. This is simple enough to research if you have a couple of products but absolutely a nightmare to accomplish manually if you have over a hundred. Also they change. When that new seller uploads an ad there is another that you need to be on to stay competitive. We offer an automated system that syncs in your UPCs with Amazons ASINS on a daily basis notifying you if there are more ads where they are and a step by step approval process to make sure the ad is appropriate. As soon as you have approved you now are on the new ads.