• Hi.

    I get the following error when trying to access my newly updated webpage. it is now runing php 7.2.

    Warning: call_user_func_array() expects parameter 1 to be a valid callback, function ‘create_my_post_types’ not found or invalid function name in /home/2/l/lysefjordensjokj/www/wp-includes/class-wp-hook.php on line 286

    Warning: Cannot modify header information – headers already sent by (output started at /home/2/l/lysefjordensjokj/www/wp-includes/class-wp-hook.php:286) in /home/2/l/lysefjordensjokj/www/wp-includes/pluggable.php on line 1223

    I know nothing about any code or programming. Anyone know if this is a quick fix.

    please help, its my girlfriends business site. 

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Moderator
    Steve Stern (sterndata) 

    (@sterndata)

    Forum Moderator & Support Team Rep

    You need to find out which plugin (or theme) is doing this and then look for an update.

    This may be a plugin or theme conflict. Please attempt to disable all plugins, and use one of the default (Twenty*) themes. If the problem goes away, enable them one by one to identify the source of your troubles.

    If you can install plugins, install “Health Check”: https://wordpress.org/plugins/health-check/ On the troubleshooting tab, you can click the button to disable all plugins and change the theme for you, while you’re still logged in, without affecting normal visitors to your site. You can then use its admin bar menu to turn on/off plugins and themes one at a time.

    Also, edit your wp-config.php and make sure WP_DEBUG is set to false, not true.

3

I'm trying to delete a record from the database programmatically. When I have it hardcoded like this it does delete a record from the database:

$wpdb->delete( $table_name, array( 'user_id' => 1, 'timeMin' => 10), array('%d', '%d') );

However, when I try to do it in a dynamic manner with variables, it doesn't work. I even tried casting the variables to int to make sure they are they right type.

$id = (int) wp_get_current_user()->ID;
$time = (int) $_POST['umjp_time'];

$wpdb->delete( $table_name, array( 'user_id' => $id, 'timeMin' => $time), array('%d','%d'));

Why doesn't the dynamic code using variables work and how do I fix this?

Follow
asked May 16, 2018 at 12:27
Willem van der Veen
27.8k15 gold badges162 silver badges139 bronze badges

3 Answers

                                              Highest score (default)                                                                   Trending (recent votes count more)                                                                   Date modified (newest first)                                                                   Date created (oldest first)                              
1

I tried like this and it's working for me.

global $wpdb;

$id = (int) wp_get_current_user()->ID;
$time = (int) '4';
$table_name = 'testtable';
$wpdb->show_errors(); 
$wpdb->delete( $table_name, array( 'user_id' => $id, 'timeMin' => $time), array('%d','%d'));
$wpdb->print_error();

What errors you are getting please can you explain? You can print errors by using show_errors() and print_error() methods.

Follow
answered May 16, 2018 at 13:22
Ankit Panchal
1494 bronze badges
  • 1
    This is probably the most correct solution. Those using DELETE FROM will work, but that isn't how wpdb is intended to work. A little explanation would work - the critical piece being the user of array('%d') which converts the integer appropriately. 
    – Brian C
     Jul 14, 2021 at 12:27
 
2
 

this is how I would recommend doing it:

function vendor_module_remove_dealer($data)
{
    global $wpdb;

    $sql = 'DELETE FROM `'. $wpdb->prefix .'my_table` WHERE `primary_id` = %d;';

    try {
        $wpdb->query($wpdb->prepare($sql, array($data['primary-id'])));

        return true;
    } catch (Exception $e) {
        return 'Error! '. $wpdb->last_error;
    }
}

this will prevent SQL Injection and delete your record safely, if it fails an error msg will be returned :)

Follow
answered May 16, 2018 at 13:18
treyBake
6,2876 gold badges25 silver badges54 bronze badges
-2

Please use below code i think it will work.

global $wpdb;

$id = (int) wp_get_current_user()->ID;
$time = (int) $_POST['umjp_time'];

$table_name = $wpdb->prefix . 'table_name';
if (!empty($id)) 
{

  $wpdb->query($wpdb->prepare("DELETE FROM $table_name WHERE user_id IN($id)"));

}
Follow
answered May 16, 2018 at 13:10
raju_odi
1,38112 silver badges27 bronze badges

Want to create a plugin to extend WooCommerce? WooCommerce plugins are the same as regular WordPress plugins. For more information, visit Writing a plugin.

Your WooCommerce extension should:

  • Adhere to all WordPress plugin coding standards, as well as best practice guidelines for harmonious existence within WordPress and alongside other WordPress plugins.
  • Have a single core purpose and use WooCommerce features as much as possible.
  • Not do anything malicious or underhanded — for example, inserting spam links or up selling services outside of the WooCommerce.com ecosystem.
  • Not subvert or override Marketplace connections in core — for example, extensions cannot create branded top level menu items or introduce their own telemetry.

Merchants make use of WooCommerce extensions daily, and should have an unified and pleasant experience while doing so without advertising invading their WP Admin or store.

Note: We provide this page as a best practice for developers.

 

Note: We are unable to provide support for custom code under our Support Policy. If you are unfamiliar with code and resolving potential conflicts, select a WooExpert or Developer  for assistance.

Check if WooCommerce is active

Most WooCommerce plugins do not need to run unless WooCommerce is already active. You can wrap your plugin in a check to see if WooCommerce is installed:

/** * Check if WooCommerce is active **/ if ( in_array( 'woocommerce/woocommerce.php', apply_filters( 'active_plugins', get_option( 'active_plugins' ) ) ) ) { // Put your plugin code here }

Note that this check will fail if the WC plugin folder is named anything other than woocommerce.

Main file naming

The main plugin file should adopt the name of the plugin, e.g., A plugin with the directory name plugin-name would have its main file named plugin-name.php.

Text domains

Follow guidelines for Internationalization for WordPress Developers, the text domain should match your plugin directory name, e.g., A plugin with a directory name of plugin-name would have the text domain plugin-name. Do not use underscores.

Localization

All text strings within the plugin code should be in English. This is the WordPress default locale, and English should always be the first language. If your plugin is intended for a specific market (e.g., Spain or Italy), include appropriate translation files for those languages within your plugin package. Learn more at Using Makepot to translate your plugin.

Follow WordPress PHP Guidelines

WordPress has a set of guidelines to keep all WordPress code consistent and easy to read. This includes quotes, indentation, brace style, shorthand php tags, yoda conditions, naming conventions, and more. Please review the guidelines.

Code conventions also prevent basic mistakes, as Apple made with iOS 7.0.6.

Custom Database Tables & Data Storage

Avoid creating custom database tables. Whenever possible, use WordPress post types, taxonomies, and options.

Consider the permanence of your data. Here’s a quick primer:

  • If the data may not always be present (i.e., it expires), use a transient.
  • If the data is persistent but not always present, consider using the WP Cache.
  • If the data is persistent and always present, consider the wp_options table.
  • If the data type is an entity with n units, consider a post type.
  • If the data is a means or sorting/categorizing an entity, consider a taxonomy.

Logs should be written to a file using the WC_Logger class.

Prevent Data Leaks

Try to prevent direct access data leaks. Add this line of code after the opening PHP tag in each PHP file:

if ( ! defined( 'ABSPATH' ) ) { exit; // Exit if accessed directly }

Readme

All plugins need a standard WordPress readme.

Your readme might look something like this:

=== Plugin Name === Contributors: (this should be a list of wordpress.org userid's) Tags: comments, spam Requires at least: 4.0.1 Tested up to: 4.3 Requires PHP: 5.6 Stable tag: 4.3 License: GPLv3 or later License URI: http://www.gnu.org/licenses/gpl-3.0.html

Plugin Author Name

Consistency is important to us and our customers. Products offered through WooCommerce.com should provide a consistent experience for all aspects of the product, including finding information on who to contact with queries.

Customers should be able to easily to differentiate a product purchased at WooCommerce.com from a product purchased elsewhere, just by looking through their plugin list in WordPress.

Thus, the following plugin headers should be in place:

  • The Plugin Author isYourName/YourCompany
  • The Developer header is YourName/YourCompany, with the Developer URI field listed as http://yourdomain.com/

For example:

/** * Plugin Name: WooCommerce Extension * Plugin URI: http://woocommerce.com/products/woocommerce-extension/ * Description: Your extension's description text. * Version: 1.0.0 * Author: Your Name * Author URI: http://yourdomain.com/ * Developer: Your Name * Developer URI: http://yourdomain.com/ * Text Domain: woocommerce-extension * Domain Path: /languages * * Woo: 12345:342928dfsfhsf8429842374wdf4234sfd * WC requires at least: 2.2 * WC tested up to: 2.3 * * License: GNU General Public License v3.0 * License URI: http://www.gnu.org/licenses/gpl-3.0.html */

Declaring required and supported WooCommerce version

Use the follow headers to declare “required” and “tested up to” versions:

  • WC requires at least
  • WC tested up to

Plugin URI

Ensure that the Plugin URI line of the above plugin header is provided. This line should contain the URL of the plugin’s product/sale page on WooCommerce.com (if sold by WooCommerce) or to a dedicated page for the plugin on your website.

Woo Plugin Header For Updates

WooCommerce core looks for a Woo line in the plugin header comment, to ensure it can check for updates to your plugin, on WooCommerce.com. This line looks like this:

Woo: 12345:342928dfsfhsf8429842374wdf4234sfd

This is only required for products sold on WooCommerce.com.  Using this line for products listed on WordPress.org or elsewhere is not required or necessary.

For products sold on WooCommerce.com, Vendors can find this snippet by logging in to their logging in to the Vendors Dashboard and going to Extensions > All Extensions. Then, select the product and click Edit product page. This snippet will be in the upper-right-hand corner of the screen.

See the plugin header comment example above for how the Woo header looks in context.

Make it Extensible

Developers should use WordPress actions and filters to allow for modification/customization without requiring users to touch the plugin’s core code base.

If your plugin creates a front-end output, we recommend to having a templating engine in place so users can create custom template files in their theme’s WooCommerce folder to overwrite the plugin’s template files.

For more information, check out Pippin’s post on Writing Extensible Plugins with Actions and Filters.

Remove Unused Code

With version control, there’s no reason to leave commented-out code; it’s annoying to scroll through and read. Remove it and add it back later if needed.

Comment

If you have a function, what does the function do? There should be comments for most if not all functions in your code. Someone/You may want to modify the plugin, and comments are helpful for that. We recommend using PHP Doc Blocks  similar to WooCommerce.

Avoid God Objects

God Objects are objects that know or do too much. The point of object-oriented programming is to take a large problem and break it into smaller parts. When functions do too much, it’s hard to follow their logic, making bugs harder to fix. Instead of having massive functions, break them down into smaller pieces.

Test Your Code with WP_DEBUG

Always develop with WP_DEBUG mode on, so you can see all PHP warnings sent to the screen. This will flag things like making sure a variable is set before checking the value.

Separate Business Logic & Presentation Logic

It’s a good practice to separate business logic (i.e., how the plugin works) from presentation logic (i.e., how it looks). Two separate pieces of logic are more easily maintained and swapped if necessary. An example is to have two different classes — one for displaying the end results, and one for the admin settings page.

Use Transients to Store Offsite Information

If you provide a service via an API, it’s best to store that information so future queries can be done faster and the load on your service is lessened. WordPress transients can be used to store data for a certain amount of time.

Logging Data

You may want to log data that can be useful for debugging purposes. This is great with two conditions:

  • Allow any logging as an ‘opt in’.
  • Use the WC_Logger class. A user can then view logs on their system status page.

If adding logging to your extension, here’s a snippet for presenting a link to the logs, in a way the extension user can easily make use of.

  $label = __( 'Enable Logging', 'your-textdomain-here' );
  $description = __( 'Enable the logging of errors.', 'your-textdomain-here' );
   
  if ( defined( 'WC_LOG_DIR' ) ) {
  $log_url = add_query_arg( 'tab', 'logs', add_query_arg( 'page', 'wc-status', admin_url( 'admin.php' ) ) );
  $log_key = 'your-plugin-slug-here-' . sanitize_file_name( wp_hash( 'your-plugin-slug-here' ) ) . '-log';
  $log_url = add_query_arg( 'log_file', $log_key, $log_url );
   
  $label .= ' | ' . sprintf( __( '%1$sView Log%2$s', 'your-textdomain-here' ), '<a href="' . esc_url( $log_url ) . '">', '</a>' );
  }
   
  $form_fields['wc_yourpluginslug_debug'] = array(
  'title' => __( 'Debug Log', 'your-textdomain-here' ),
  'label' => $label,
  'description' => $description,
  'type' => 'checkbox',
  'default' => 'no'
  );

view raw
wc-view-log-setting-snippet.php
hosted with 

 by GitHub

Error codes

This information is intended for the third-party developers so products they write can better handle errors. Error codes are produced by the Product Build Server when uploading a new submission or updating an existing product on the Marketplace.

error_success

The operation has completed successfully.

error_pbs_prepare_apache

Internal error with the Product Build Server – cannot initialize the Apache daemon.

error_pbs_prepare_mysql

Internal error with the Product Build Server – cannot initialize the MySQL daemon.

error_pbs_prepare_wp

Internal error with the Product Build Server – cannot initialize WordPress.

error_pbs_prepare_wc

Internal error with the Product Build Server – cannot initialize WooCommerce.

error_pbs_prepare_dependencies

Internal error with the Product Build Server – cannot configure dependencies.

error_pbs_test_malware_scanning

Malware scanning error. This can happen if your product contains malware in the code.

Here’s an example output:

ObfuscatedPhp /tmp/product_clone/woocommerce-example/includes/views/html-settings-page.php 0x406:$ini_set: ini_set( 0x506:$ini_set: ini_set( ObfuscatedPhp /tmp/product_clone/woocommerce-example/includes/views/html-extras-page.php 0x406:$eval: exec(

This means that the character at the absolute position 0x406 (1030) and 0x506 (1286) in the file html-settings-page.php doesn’t pass the $ini_set rule, because it is using call_user_func in that file. Also, the other file html-extras-page.php doesn’t pass the rule $register_function which is using exec call.

error_pbs_test_extracting

Cannot extract the product. Most common issue is the top directory of the zip does not match its slug.

error_pbs_test_phpcs

phpcs checks failed. The check uses the WooCommerce-Core sniffs with following phpcs.xml:

  <?xml version="1.0"?>
  <ruleset name="WordPress Coding Standards">
  <description>WooCommerce extension PHP_CodeSniffer ruleset.</description>
   
  <!– Exclude paths –>
  <exclude-pattern>tests/</exclude-pattern>
  <exclude-pattern>woo-includes/woo-functions.php</exclude-pattern>
  <exclude-pattern>woo-includes/class-wc-dependencies.php</exclude-pattern>
  <exclude-pattern>*/node_modules/*</exclude-pattern>
  <exclude-pattern>*/vendor/*</exclude-pattern>
   
  <!– Configs –>
  <config name="minimum_supported_wp_version" value="4.7" />
  <config name="testVersion" value="5.6-" />
   
  <!– Rules –>
  <rule ref="WordPress-Extra">
  <exclude name="Generic.Commenting.DocComment.SpacingAfter" />
  <exclude name="Generic.Files.LineEndings.InvalidEOLChar" />
  <exclude name="Generic.Functions.FunctionCallArgumentSpacing.SpaceBeforeComma" />
  <exclude name="PEAR.Functions.FunctionCallSignature" />
  <exclude name="Squiz.Commenting" />
  <exclude name="Squiz.PHP.DisallowSizeFunctionsInLoops.Found" />
  <exclude name="Squiz.WhiteSpace" />
  <exclude name="WordPress.Arrays" />
  <exclude name="WordPress.Files.FileName" />
  <exclude name="WordPress.NamingConventions" />
  <exclude name="WordPress.Security.ValidatedSanitizedInput.MissingUnslash" />
  <exclude name="WordPress.WP.I18n.NonSingularStringLiteralText" />
  <exclude name="WordPress.WhiteSpace" />
  </rule>
   
  <rule ref="WooCommerce-Core">
  <exclude name="Core.Commenting.CommentTags.AuthorTag" />
  <exclude name="WordPress.PHP.DontExtract" />
  <exclude name="Generic.Arrays.DisallowShortArraySyntax" />
  <exclude name="Generic.WhiteSpace.ScopeIndent.Incorrect" />
  </rule>
   
  <rule ref="PHPCompatibility">
  <exclude-pattern>tests/</exclude-pattern>
  </rule>
  </ruleset>

view raw
phpcs.xml
hosted with 

 by GitHub

To install locally:

  1. Go to your product directory.
  2. Install WooCommerce sniffs with composer require woocommerce/woocommerce-sniffs.
  3. Put phpcs.xml above in the product directory.
  4. Run ./vendor/bin/phpcs --warning-severity=0 -s --ignore-annotations --extensions=php,html . .

error_pbs_test_installing

Cannot install the product. Most common issue is the top directory of the zip does not match its slug.

error_pbs_test_activating

Cannot activate the product. Refer to the build output for more details.

error_pbs_test_deactivating

Cannot deactivate the product. Refer to the build output for more details.

error_pbs_test_host_plan_installing

This error means that your product is incompatible with other products in the host plan. Refer to the build output for more details.

error_pbs_test_host_plan_activating

This error means that your product is incompatible with other products in the host plan. Refer to the build output for more details.

error_pbs_test_host_plan_deactivating

This error means that your product is incompatible with other products in the host plan. Refer to the build output for more details.

error_pbs_missing_theme_info_file

Your theme is missing the theme info file theme_info.txt under the root directory.

error_pbs_incomplete_theme_info

Your theme info file theme_info.txt contains malformed data structure. It should contain the product ID, hash and main file, all separated by new lines. For example:

887931 2429c1dde521031cd053886b15844bbf storechild/style.css

error_pbs_incomplete_theme_header

Your theme main file contains malformed data structure. Provide Theme Name, Version, and the Woo headers in your main file.

error_pbs_incomplete_plugin_header

Your plugin main file contains malformed data structure. Provide Plugin Name, Version, and the Woo headers in your main file.

error_pbs_invalid_woo_header

Your product main file contains an invalid Woo header structure. Use the format ID:HASH. For example:

* Woo: 390890:911c438934af094c2b38d5560b9f50f3

error_pbs_invalid_id

Your product main file contains an invalid product ID in the Woo header.

error_pbs_invalid_hash

Your product main file contains an invalid hash in the Woo header.

error_pbs_missing_main_file

Your product is missing the main file.

error_pbs_missing_changelog_file

Your product is missing the changelog.txt file.

error_pbs_product_version_mismatch

The version in your product’s main file does not match with the provided version in changelog.txt.

error_pbs_invalid_changelog_format

Your product contains malformed changelog.txt structure. Refer to changelog.txt as an example.

 

 

 

https://docs.woocommerce.com/document/create-a-plugin/

https://docs.woocommerce.com/document/managing-orders/

 

 

Orders are created when a customer completes the checkout process, and they are visible to users with Admin and Shop Manager roles only. Each order is given a unique Order ID.

Order IDs are non-sequential as they use the default WordPress ID approach. For sequential order numbers, you can use Sequential Order Numbers Pro.

Order Statuses

An order also has a Status. Order statuses let you know how far along the order is, starting with “Pending payment” and ending with “Completed.” The following order statuses are used:

  • Pending payment — Order received, no payment initiated. Awaiting payment (unpaid).
  • Failed — Payment failed or was declined (unpaid) or requires authentication (SCA). Note that this status may not show immediately and instead show as Pending until verified (e.g., PayPal).
  • Processing — Payment received (paid) and stock has been reduced; order is awaiting fulfillment. All product orders require processing, except those that only contain products which are both Virtual and Downloadable.
  • Completed — Order fulfilled and complete – requires no further action.
  • On hold — Awaiting payment – stock is reduced, but you need to confirm payment.
  • Canceled — Canceled by an admin or the customer – stock is increased, no further action required.
  • Refunded — Refunded by an admin – no further action required.
  • Authentication required — Awaiting action by the customer to authenticate the transaction and/or complete SCA requirements.

Visual Diagram to Illustrate Order Statuses

This visual representation follows an order through its statuses from “Pending payment” to “Completed”, “Canceled” or “Refunded.”

Order Statuses and Payment Gateways

More about how order statuses relate to payment gateways in the Troubleshooting section.

Order Statuses and Emails

More about the different emails that are automatically sent at Email Settings.

If you are using PayPal and orders are staying in Pending, you may have an IPN issue. See the troubleshooting section at Debugging IPN Issues

Viewing and Managing Multiple Orders

Orders Overview

When a shop starts taking orders, the Orders management page begins to fill up. Go to: WooCommerce > Orders.

Each row displays several details. Some are there by default, others can be added. These are the available options:

  • Order number and customer name,
  • Date of purchase,
  • Order status,
  • Billing address,
  • Shipping address,
  • Purchase total, and
  • Actions.

To change these columns:

  • Go to: WooCommerce > Orders.
  • Select Screen Options in the top right corner.
  • Select which Columns to show.
  • Select how many Items you want to be displayed on each page.
  • Then Apply.

Filter and Arrange Orders

Filter orders by Date (month/year) or by registered customer.

  • Select the month, or search for a customer.
  • Select Filter.

Arrange orders in ascending or descending order by Order number, Date or Total by select the heading.

Note that the “Total” column does not take the refunded amount into consideration.

Click the order number and customer name to see the Single Order page, where you can also Edit order details, Update Status, and Add Notes. More details on that in Viewing and Editing Single Orders.

Searching and Finding Orders

Orders can be found using the search box at the top right of the order list. Enter an order number, customer name, or other information shown in the order list such as address. Click Search orders or tap return on your keyboard and search results will show a list of matching orders.

Previewing Orders

Order rows have a Preview “eye.”

Clicking Preview opens a Modal, containing the order number, order status, billing details, payment method, shipping details, shipping method, items ordered, and the option to change the order status.

Order Statuses in the Overview

Order Statuses are color-coded and descriptive.

  • Canceled – Grey
  • Completed – Blue
  • Failed – Red
  • On Hold – Orange
  • Pending Payment – Grey
  • Processing – Green
  • Refunded – Grey

Order Actions

Hovering over an order Status displays Notes made on the order.

At the end of a row are shortcut buttons to quickly mark orders as Processing or Complete.

Viewing and Editing a Single Order

From the Single Order page not only can you view all order data, but also edit and update.

  • Change the order status.
  • Edit order items – modify the product, prices, and taxes.
  • Stock – Reduce and restore stock for an order
  • Order Actions – Email order details to customer (handy if manually creating an order for your customers) or Regenerate download permissions
  • Modify product Meta to edit product variations by removing and adding meta
  • Apply coupons. You will need to know the coupon code to apply to the order. Coupon usage counts are tracked, and coupons can also be removed from orders. Note: the order must be unpaid for coupons to have an affect
  • Add fee. You can enter an amount or percentage to add a fee to an order. Negative fees will apportion taxes between all other items, and will not make the cart total go below zero

Order Details

Viewing Order Details

The Order Details panel you can view:

  • Order number
  • Payment details
  • Order date and time
  • Order status
  • Customer details:
    • Username and email, together with a link to view their profile and other purchases the customer may have had in the past
    • Billing details
    • Shipping details

Editing Order Details

Most of the details in this section can be updated and/or changes.

  • To change the date and time, use the dropdown date selector and the quantity selectors for the time.
  • To change the status, choose the right status in the dropdown.
  • To change the customer, select the current customer and search for the new customer.

Under “Billing” and “Shipping”, several other details can be changed. In order to do so, select the pencil icon next to each of them.

  • Under “Billing”, the following things can be changed:
    • Billing address — this can also be loaded from the customer’s profile by selecting “Load billing address”
    • Email
    • Phone number
    • Payment method and details
  • Under “Shipping”, the following things can be changed:
    • Shipping address — this can also be loaded from the customer’s profile or copied from the billing address
    • Customer provided note

Once you’ve made the necessary changes, select Update to update the order.

Order Items and Totals

Viewing Order Items

The next panel on the order page is the Order Items panel. This contains the product items, the shipping details, and the order summary.

  • Each product item row lists:
    • Product image
    • Product name
    • Single product Cost
    • Quantity
    • Total (Cost x Quantity, with discounts taken into consideration)
    • Taxes
  • Below that, the shipping details are displayed. This will include:
    • Shipping method
    • Boxed items
    • Total cost
    • Taxes
  • The last section contains an overview of the order costs. This section will change if an order is refunded. By default, it will include:
    • Items subtotal — cost excluding tax
    • Coupon(s) — amount deducted based on the use of coupons; the coupons used are displayed left in this section
    • Shipping — the shipping cost for the order
    • Taxes — the amount of taxes for the whole order; this will be replaced by the tax code applied to the order
    • Order total — the total of the above costs
    • Finally, below the line, an overview of what is paid and the fees taken by payment gateways

Editing or Adding Order Items

Apart from refunding, order items can not be edited, unless the order status is “Pending payment”, or “On hold.”

Product items. Select the pencil icon next to a product line to edit.

The following product items can be edited:

  • Add Meta — Add and remove meta to change product variable options.
  • Quantity — Number of items the customer is purchasing.
  • Total — Line price and line tax before pre-tax discounts.
  • Tax — Tax cost. For example, if a customer is tax-exempt you may want to remove the taxes.

Other actions. Next, you can do four actions at the bottom of this window:

  • Add item(s) — this will show you six new options:
    • Add product(s) — Add additional products to the order.
    • Add fee — Add an additional fee, such as gift wrapping.
    • Add shipping — Add a shipping cost. When you’ve done this, select the pencil icon to update the name, the method, the cost, and the tax.
    • Add tax — Add an additional tax code to every section in the order.
    • Cancel — Cancel if you do not want to make any changes.
    • Save — Save once the changes are made.
  • Once you’ve done this, you can select Recalculate if you want to automatically perform new calculations based on store settings. This can be handy if you are adding or removing products, coupons, shipping methods, etc. Note that any tax changes that you’ve manually included will be removed as the tax settings in your store will apply based on the customer address.

  • Apply coupon — If your customer forgot to add the coupon could or you want to reward the customer before they pay, selecting this option will show a modal that allows you to apply a coupon code.
  • Refund — to refund the customer. For more information about Manual and Automatic Refunds, see WooCommerce Refunds.

Custom Fields

To add custom meta fields, use the Custom Fields metabox:

Order Notes

The Order Notes panel displays notes attached to the order and can be used for storing event details, such as payment results or reducing stock levels, or adding notes to the order for customers to view. Some payment gateways also add notes for debugging.

The following note types are possible:

  • Purple: System status notices, such as payment gateway details.
  • Grey: General status updates, such as status changes or private notes. Customers do not see these notes but may receive notification of them, e.g., when the status changes from processing to completed, an email may be sent (depending on your settings).
  • Blue: Notes to the customer. Customers receive notes via email but can view them by viewing an order in their My account section.

Notes can be a powerful tool for communicating with customers or other store managers. Need to add a tracking number for shipping? Is stock delayed? Add a customer note, and they are automatically notified.

To add a note,

  • Use the textarea to add the content of the note.
  • Select Private note or Note to customer in the dropdown.
  • Select Add.

Manually Adding an Order

To add an order:

  1. Go to: WooCommerce > Orders.
  2. Use Add New at the top of the page. The Single Order page appears.
  3. Input customer details, add line items, apply coupons, apply fees and calculate totals. These are the same as the Editing or Adding Order Items.
  4. Set a status for the new order, e.g., If it needs to be paid, use “Pending payment.”
  5. Save.

Use the Order Actions dropdown to Email order details to the customer with payment instructions.

Paying for an Order

Orders that are “Pending payment” can be paid for through the payment link.

As the shop manager, you can find this link on the order overview:

  • If the customer is a Guest, anyone with the right link will be able to view the payment page and pay for the order.
  • If the customer is registered on your site,
    • Only this customer will be able to see the payment link once they are logged in.
    • The customer can also find the order in: My Account > Orders.

If the customer is assigned to the order, they will be asked to log in before paying:

  • If you are the store owner and wish to pay on behalf of the customer, consider using User Switching (not endorsed by WooCommerce.com) to log in to the customer’s account and complete the payment as them.

Removing Personal Data

Starting with WooCommerce 3.4+, it is possible to remove customer data.

  • Go to: WooCommerce > Settings > Accounts & Privacy.
  • Enable Allow personal data to be removed in bulk from orders.
  • Save changes.

This option is now available for orders:

  • Go to: WooCommerce > Orders.
  • Select the orders that need personal data removed.
  • Select Bulk Actions > Remove personal data.
  • Select Apply.

Please note, that once you press Apply this will remove personal data with no further warning. Orders will appear on the Orders screen like this:

On an individual order, data is updated like this:

  • Failedpending, and canceled orders which get cleaned up will be moved to the trash.
  • Completed orders which get cleaned up will be anonymized so sales stats are unaffected (as above).
  • Inactive accounts will be deleted. An inactive account is one which has not been logged in to, or which has not placed orders, for the specified time.

Personal data removal can be automatically associated with account erasure requests. WordPress allows deleting user details upon request via Tools > Erase Personal Data. This removal can now also be associated with the orders of this user.

  • Go to: WooCommerce > Settings > Accounts & Privacy.
  • Under Account erasure requests:
    • Enable Remove personal data from orders on request, if you also want to remove order data when this is done
    • Enable Remove access to downloads on request, if the customer should no longer access the download links once their personal details have been removed.

Personal data retention can also be automated.

  • Go to: WooCommerce > Settings > Accounts & Privacy
  • Under Personal data retention, set thresholds for inactive accounts and for orders with different statuses.
  • Save changes.

If enabled, this cleanup will run via a daily cron job. Inactive accounts are tracked using metadata, and only subscribers/customer accounts are removed.

Multi-Site Orders

Starting with WooCommerce 3.4+ there is now a widget that appears under Dashboard that shows order information from across all sites. You can click on an order to be taken to the details of the order on that site.

Troubleshooting

Understanding Order Statuses in Relation to Payment Gateways

STATUSDESCRIPTIONPAYMENT GATEWAY COMMENTSON HOLDPENDINGPROCESSINGCOMPLETEDFAILEDAUTHENTICATION REQUIRED

Awaiting payment – stock is reduced, but you need to confirm payment Usually seen with payment methods when you need to manually confirm, such as BACS (bank transfer) or cheque.

You’ll also see this when the gateway is set to authorize instead of capture a charge: the shop owner will need to manually switch the status to processing.
Order received (unpaid). Most gateways will report back and set the order status to Processing (payment successful) or Failed (payment unsuccessful).  If the shop never receives either signal, it keeps the status on Pending.

This tends to be a misconfiguration of payment notification URLs or a plugin conflict.
Payment received and stock has been reduced- the order is awaiting fulfillment. All product orders require processing, except those with only products that are both digital and downloadable. If the payment has been successful and the order does not contain Digital or Downloadable products, the order will be set to Processing.

This is the shop owner or warehouse’s cue to ship the order and manually mark it as completed.
Order fulfilled and complete – requires no further action These generally aren’t interesting because everything has gone correctly.
Payment failed or was declined (unpaid). The order can be manually canceled, but this status can come up if the payment window has expired. It can happen for a few reasons:
  • order was abandoned  before payment was completeThe hold stock window expired without a response
  • Same reasons as Pending
Customer must complete requirements for SCA. It can occur when:
  • a new customer makes a purchase
  • an existing subscription renews

Questions

Do you still have questions and need assistance? 

  • Get in touch with a Happiness Engineer via our Help Desk. We provide expert priority support for WooCommerce.com and Jetpack customers but not other third-party plugins.
  • If you are not a customer at WooCommerce.com, we recommend finding help on the WooCommerce Support Forum or hiring a recommended expert on our customizations page.

+ Recent posts