Rixxo Knowledge Base

Step 1: Issuing a VPN Bundle In your Sonassi Dashboard go to stacks Then select your stack Select Vpn bundles from the left-hand menu And enter a user's email to issue them a VPN bundle. The user will receive 2 emails with instructions to set up and conne

An easy way to track conversion with Facebook or any conversion script is to add a small script to the thank you page with a hook. Add this to the end of your functions.php file. Insert and update your tracking code and adjust if you want to track values.

Welcome to Magento 2 Resources appendix.png?version=1&modificationDate=1564661728596&cacheVersion=1&api=v2&width=100 Use the navigation panel on the left for quick shortcuts and navigating the site

Methods Scripts & API For seasoned developers, you might find it easier to transfer from one system to the next via an API or between databases. This has the added benefit you can keep in sync whilst preparing a new site or system. Import Export Tools The

If you are changing settings in your admin dashboard and they are not taking effect then the setting may be being overwritten by a configuration lower down the hierarchy of the store structure. https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/atta

A script to quickly compress the Magento 2 public folder without the complied files, such as generated, static etc. If moving you will need to deploy afterwards to regenerate the files we have not compressed and moved. tar --exclude=./generated/code --exc

UPDATE Unfortunately layout updates have been removed from Magento since 2.3.4 and if your version is greater than this you will now have to make a specific layout update https://devdocs.magento.com/guides/v2.3/frontend-dev-guide/layouts/xml-manage.html#c

This code will setup the higest level admin with the username socialresponse when run as an SQL query in the database of a wordpress install. If there is a prefix on the tables you will need to preprend these to table name after the database name. ie wp_

An easy to use CLI program for Magento 2 to remove duplicate category URLS and duplicate product URLS in Magento 2 https://github.com/c1gee/urldedup https://github.com/c1gee/urldedup

If you MagManager has databases in that you wish to get rid of you can delete them in c:\Users\%username%\appData\Local\eMagicOne Store Manager for Magento\LocalMySQLData\data\%database name%

If you find youself with a blank admin screen http://support.social-response.co.uk/support/solutions/articles/1000044163 in Wordpress it's probably because of a plugin issue. You can disbale all of your plugins in the database and re-enable them one by on

DNS stands for Domain Name System (DNS) and works as an address book for pages on the internet. It is used to link domain names to different IPs (server addresses) to make navigation simpler. To make changes to your DNS and point your domain name to your

Have you accidentally set a load of values at store level and not on the default level? Have you been rationalising attributes leaving values unused? Have you been getting errors when adding images or have unused images in your media folder? A great littl

Welcome to Email Marketing appendix.png?version=1&modificationDate=1564661728596&cacheVersion=1&api=v2&width=100 Use the navigation panel on the left for quick shortcuts and navigating the site

01 | Is your brand recognisable in the from name/ address? Choose a from name and address that represents your brand and clearly identifies the sender. 02 | Does the subject line support the content in your email? Make sure the copy, headings, rich cont

This one can be a mine field. There are an array of reasons why the site might not be sending email so let's just check in a couple. 1) In your config.php a command disabling all email in in there. This is common for developers to put this in there when

It is much better to use the store variable for links than hard coding as it makes moving content between dev, live and staging sites easier and more accurate. To find and replace in Magento CMS blocks and CMS pages content use the following SQL in the da

A useful script for finding products with duplicate URLS in Magento 2. SELECT Count(*),value FROM /*PREFIX*/catalog_product_entity_varchar v WHERE EXISTS (SELECT * FROM /*PREFIX*/eav_attribute a WHERE attribute_code = "url_key" AND v.attribute_id = a.attr

You can choose the Catalog view option as grid only or list only. The default is Grid/List. You can change it to List/Grid as well. To do so: Go to Store -> Configuration -> Catalog -> Storefront Change the List Mode.

You can quickly find out and serve us the information we need by running the following command. Replace /path/to/software/installation as necessary cd /path/to/software/installation du -hsL . \ --exclude="var/log" \ --exclude="var/session" \ --exclude="va

So that we can quote accurately, it's important that we know how much MySQL disk space you are currently consuming for your Magento or Adobe Commerce store. You can easily find out the information we need by running the following command. SELECT IFNULL(B.

If you are looking to change the salutation in a Quote email for Cart2Quote to be First Name instead of full name you can change the following <p class="greeting">{{trans "Hello %customer_name," customer_name=$quote.getCustomerName()}}</p> becomes <p clas

A more elegant solution for discontinued products and also products that might not be available for a long time. This was written as a guide for a client but can be used and adjusted with your own knowledge and preferences There are 4 parts to this. In

When working with Agencies and Freelancers on your Magento store there are often times when you will want to give them access. Here is a process to follow that will make it easy to manage, maintain and update as the services you use the agency change or e

Issue Trying to upload an image to a product page results in the image disappearing or being replaced with the placeholder image. Steps to reproduce Upload image via uploader or drag and drop Tag image as base, small, thumbnail Save product page Result Im

Let's say you want to put every price up in your catalog. Or maybe even down. You can do it by installing an extension. You can also do it by exporting all of you products and remimporting them with the price difference. You can also do it by an SQL com

1. Create a new Custom SQL Give it a name such as Products - Price Increase SELECTION by X% 2. Add the script below for a price increase UPDATE /*PREFIX*/catalog_product_entity_decimal val SET val.value = (val.value * 1.:`deci.Decimal`) WHERE val.attribut

If Magento is running slowly after a period of quiet time on the site it could be a result of some garbage collection issues in PHP Restart the services according to Serverpilots instructions https://serverpilot.io/docs/how-to-restart-services https://ser

To mark a field as blank when importing a CSV to Magmanager , add to single quotes , '' , to the field in the spreadsheet. To be extra clear this is not a double quote “ , its two of this character : '. If this does not work, check you have the latest upd

When performing a bridge test , if you receive this error : Deprecated: Unparenthesized `a ? b : c ? d : e` is deprecated. Use either `(a ? b : c) ? d : e` or `a ? b : (c ? d : e)` in /domains/speed.buildingmaterials.co.uk/___deploy/releases/6732f3404eccd

In some instances, mag manager will not accept comma-separated values for things like attribute options. This means that the attributes all get added together as options like this “a,b,c” instead of “a” , “b” , “c”. First of all, ensure that your attribut

If you are working on a development site or staging site then you may want to have it password protected via .htpasswd or restricting IP To allow MagManager to connect in Bridge Mode simple add the following code after the current instructions in your hta

A quick and easy way to clear all generate files in Magento 2 command line rm var/cache/* var/generation/* var/view_preprocessed/* var/page_cache/* pub/static/frontend/* pub/static/adminhtml/* -R

Should items from Magento not appear in Salesforce Lightning it could be that you have become unauthorized. To reauthorise Magento and Salesforce go to YOURDOMAIN/controlpanel/salesforce/login/ Visiting this URL when logged in to the Magento admin will re

Sometimes a product URL might look like this /catalog/product/view/id/2700/category/57/ instead of /category/productname This is most commonly down to an import tool such as MagManager or directly manipulating the database. Use a CLI tool such as this one

Whilst working on a catalog of 36000 items imported from a previous system we ended up with a lot of very poor "size attributes". A quick bit of Googling led us to this answer https://magento.stackexchange.com/questions/1110/delete-unused-attribute-value

Sometime when using import tools such as Mag Manager you can accidently set different data for different store views. Assuming that your Default Store View id is 0 this SQL will reset all products back to Use Default Store View in Magento 2 DELETE FROM `c

Describe when someone would need this information. For example "when connecting to wi-fi for the first time". Clearing all products Clearing all reviews Clearing all customers Clearing all attributes Clearing all attribute sets Clearing all categories Cle

Welcome to the Rixxo Resources and FAQ space Use the navigation panel on the left for quick shortcuts and navigating the site Search this space Frequently used articles Add links to popular how-to and troubleshooting articles. Highlight important document

Prices are wrong in the Google Shopping Feed Cause The most common cause of the incorrect price in the feed is the incorrect price in the configuration. One of the most common reports is “special price not appearing in Google shopping feed” By default, th

MagManager Script for Switching to Configurable Model - Works with product selection SQL /* Look up the configurable products entered and change the visibility to C&S (4) */ UPDATE /*PREFIX*/catalog_product_entity_int SET value = 4 WHERE entity_id in (&`p

The easiest way to reduce comment spam is too turn off comment in Wordpress all together. If you aren't promoting conversations and driving them then the chances are people won't be taking part that much and the benefits of comment content are being out

Where can i use page builder? Most places you can add content you can use page builder, but with the exception of custom coded blocks and the product item, you can normally only use it for static content. Static pages can be accessed from admin → content

If you charge VAT you will know that for non VAT customers across Europe you must charge them VAT like anybody else in the UK. (Read more here https://www.gov.uk/vat-exports-dispatches-and-supplying-goods-abroad#sales-in-another-eu-country-to-someone-who-

Sometimes you might get an error that looks like this in your browser There has been an error processing your request Exception printing is disabled by default for security reasons. Error log record number: 73693983689 A Magento 2 top development tip to h

The Lumarix instruction manual is found here https://rixxo-hq.atlassian.net/wiki/spaces/LM/overview. https://rixxo-hq.atlassian.net/wiki/spaces/LM/overview You will also find our support desk suggests articles from the manual as you type when creating a t

So you have gone to your login URL, most likely this is yourdomain.tld/admin ( you should really change this for security reasons), and have entered your login details as normal. You are then presented with a blank white page. This is most likely going to

This is the display when a user attempts to log on when not approved, this is the documented functionality for the tool. Users can not log in without being approved, they may receive a password but their account is inaccessible until they get approval. ht

Welcome to Wordpress Resources appendix.png?version=1&modificationDate=1564661728596&cacheVersion=1&api=v2&width=100 Use the navigation panel on the left for quick shortcuts and navigating the site

Commonly a database error with user_meta in the Wordpress database. Issue #1 - Corrupted Database Table Login to the database via MySQL Find table wp_user_meta When you open the table you may see the error "wp_user_meta is marked as crashed and should be