Welcome to Wordpress Resources
Use the navigation panel on the left for quick shortcuts and navigating the site
Search the whole space for keywords, phrases and more!
Space Index
|
|||||||||||||||||||||||||||||||
0-9 |
AAccessing Mailhog on SonassiStep 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
Adding Facebook Conversion Pixel to Woocommerce Checkout
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.
Admin Settings
Adobe Commerce 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
|
||||||||||||||||||||||||||||||
BBlocks & WidgetsBulk Import Historical Orders & Customers 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
|
CCart2QuoteCategories Changing an admin setting has no effect 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
CLI Tar Compress Magento 2 for backup or migration without clutter
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
CMS Pages
Common Layout Update XML for Magento 2 - Cheat Sheet 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
Create a user directly in the database.
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_
|
||||||||||||||||||||||||||||||
DDe-Dupe Magento URLS on bulkAn 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
Delete local databases in MagManager
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%
Disable All Wordpress Plugins Via The Database
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 Changes for go live
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
|
EEAV Cleaner - Clear unused media, attributes and reset store valuesHave 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
Email Marketing
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
Email Marketing Pre-Send Checklist
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
Emails Not sending from Wordpress forms
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
|
||||||||||||||||||||||||||||||
FFind and Replace Hard Coded URLS with Store URL Variable in Magento 2It 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
Find Products with Duplicate URLS in Magento 2
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
|
G |
||||||||||||||||||||||||||||||
HHostingHow can I disable the View as grid/list buttons in Magento 2.* 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.
How much disk space is Magento / Adobe Commerce using on the server
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
How much MySQL disk space is being used
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.
How to add First Name to Magento 2 Transactional Emails for Cart2Quote
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
How to Discontinue Products in Magento 2
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
How to Give an Agency/freelancer Access to Your Magento Store
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
|
IImages not saving when uploadingIssue 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
Increase or Decrease ALL Magento 2 Prices by 10% | How to
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
Increase or decrease product selection price by percent in MagManager
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
Integrations
|
||||||||||||||||||||||||||||||
J |
K |
||||||||||||||||||||||||||||||
L |
MMagento 2 Running Slowly on Digital Ocean with ServerpilotIf 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
Magmanager - Marking value as blank on csv import
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
Magmanager Deprecated: Unparenthesized `a ? b : c ? d : e` is deprecated.
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
Magmanager not importing comma-separated values
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
MagMananger working with Magento 2 Password Protected with .htpasswd
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
|
||||||||||||||||||||||||||||||
N |
O |
||||||||||||||||||||||||||||||
PProducts |
QQuickly remove all generated files CLI command line Magento 2A 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
|
||||||||||||||||||||||||||||||
RRe-authorising Magento 2 and SalesforceShould 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
Regenerate Category and Product URLs
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
Remove unused attribute options in Magento 2
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
Reset ALL products in Magento 2 to Default Store 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
Reset Magento 2 Database and clear all data
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
Rixxo Knowledge Base
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
|
SSimple Google Shopping Feeds by Wyomind - Common IssuesPrices 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
Switching Between Configurable and Simple product structures
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
|
||||||||||||||||||||||||||||||
TTransactional EmailsTurning off comments in wordpress. 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
|
UUsing Page BuilderWhere 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
|
||||||||||||||||||||||||||||||
VVAT TAX import for WooCommerce - UK Seller to EU (Europe) CustomersIf 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-
View Magento exception errors in your browser
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
|
WWhere to find Lumarix Instruction ManualThe 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
White Screen in Wordpress Admin - After Login
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
Woocommerce & Other Wordpress Ecommerce Solutions
Woocommerce Login Process 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
Wordpress
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
|
||||||||||||||||||||||||||||||
X |
YYou do not have sufficient permissions to access this page.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
|
||||||||||||||||||||||||||||||
Z |
!@#$ |
||||||||||||||||||||||||||||||