WP All Import: calculate discounts using your own function

Posted on May 11, 2015 by rolandow

Using WP All Import, I wanted to use a discount on our prices, but do the math myself. This way I could round the discounts by x.95 or x.45 instead of other weird prices.

The manual suggests you put your function in the functions.php of your theme. But I don’t want the function to be gone when updating the theme, and neither want to create a child theme just to put this one stupid function in. So I thought I’d create a plugin.

This seems to work perfectly. Just put in this code in your /wp-contents/plugins directory. Save this code to, for example, wp-all-import-discount.php.

<?php
/*
Plugin Name: WP All Import Discount Price 
Plugin URI: http://www.yourwebsite.com/
Version: 1.0 
Author: Steve Gates 
Description: A simple static plugin that has a function to calculate a price by a discount percentage. It creates nice prices, ending with 0.95 or 0.45 
*/

function wpai_discount($price, $discount=0.9) {
    return (ceil(($discount*$price)*2)/2)-0.05;
}

<?php

Plugin Name: WP All Import Discount Price

Plugin URI: http://www.yourwebsite.com/

Version: 1.0

Author: Steve Gates

Description: A simple static plugin that has a function to calculate a price by a discount percentage. It creates nice prices, ending with 0.95 or 0.45

function wpai_discount($price, $discount=0.9) {

return (ceil(($discount*$price)*2)/2)-0.05;

}

Now you can easily use it in your import config:

As second parameter you can use the discount you want. Use 0.9 for 90%, 0.5 for 50%, etc.

WP All Import cron from CLI (update)

Posted on November 25, 2014 by rolandow

My previous post about executing the WP All Import cron jobs with PHP cli didn’t work too well. Apparently the processing part still stops executing after a while. I ended up with import jobs stating “last activity 5 hours ago”.

Still I don’t want to run this through the webserver. So I wrote a little wrapper shell script to execute my imports in cron. It checks if the line “is not triggered” was partially returned. The wp cron script would return “<p>Import #26 is not triggered. Request skipped.</p>” if you execute the processing action without triggering it first. In other words: the import is really complete now.

I put the shell script outside my document root, and it uses the “logs” directory to store the log files. So make sure this directory is writable and points to the right path.

#!/bin/bash
 
while getopts ":j:" opt; do
  case $opt in
    j)
      jobId=$OPTARG
      ;;
    \?)
      echo "Invalid option: -$OPTARG" >&2
      ;;
   :)
      echo "Option -$OPTARG requires an argument." >&2
      exit 1
      ;;
  esac
done

if [ "$jobId" = "" ]; then
  echo No job id
  exit 1
fi

# Set magic variables for current FILE & DIR
__FILE__="$(test -L "$0" && readlink "$0" || echo "$0")"
__DIR__="$(cd "$(dirname "${__FILE__}")"; echo $(pwd);)"
LOGFILE="${__DIR__}/logs/wpai_cron_${jobId}.log"
CURLOG="${__DIR__}/logs/wpai_cron_${jobId}_current.log"
DONE=0

function log {
  echo "$(date): $*" >>$LOGFILE
}


log "Start import for jobID $jobId"

cd $__DIR__/public_html
php -e -r 'parse_str("import_key=xxYourKeyxx&import_id='$jobId'&action=trigger", $_GET); include "wp-cron.php";' >>$LOGFILE 2>&1
sleep 1

while [ $DONE -eq 0 ]
do
  php -e -r 'parse_str("import_key=xxYourKeyxx&import_id='$jobId'&action=processing", $_GET); include "wp-cron.php";' >$CURLOG 2>&1
  cat $CURLOG >>$LOGFILE
  DONE=$(grep 'is not triggered' $CURLOG | wc -l)
  sleep 1
done
rm $CURLOG

log "End of import for jobId $jobId"
log ""
log ""

#!/bin/bash

while getopts ":j:" opt; do

case $opt in

jobId=$OPTARG

;;

\?)

echo "Invalid option: -$OPTARG" >&2

;;

echo "Option -$OPTARG requires an argument." >&2

exit 1

;;

esac

done

if [ "$jobId" = "" ]; then

echo No job id

exit 1

# Set magic variables for current FILE & DIR

__FILE__="$(test -L "$0" && readlink "$0" || echo "$0")"

__DIR__="$(cd "$(dirname "${__FILE__}")"; echo $(pwd);)"

LOGFILE="${__DIR__}/logs/wpai_cron_${jobId}.log"

CURLOG="${__DIR__}/logs/wpai_cron_${jobId}_current.log"

DONE=0

function log {

echo "$(date): $*" >>$LOGFILE

}

log "Start import for jobID $jobId"

cd $__DIR__/public_html

php -e -r 'parse_str("import_key=xxYourKeyxx&import_id='$jobId'&action=trigger", $_GET); include "wp-cron.php";' >>$LOGFILE 2>&1

sleep 1

while [ $DONE -eq 0 ]

php -e -r 'parse_str("import_key=xxYourKeyxx&import_id='$jobId'&action=processing", $_GET); include "wp-cron.php";' >$CURLOG 2>&1

cat $CURLOG >>$LOGFILE

DONE=$(grep 'is not triggered' $CURLOG | wc -l)

sleep 1

done

rm $CURLOG

log "End of import for jobId $jobId"

log ""

Now just put this in your /etc/cron.d/yoursite:

#
# Run product imports every morning at 6 am
#
0   6 * * *    yourwebsite    /home/yourwebsite/wpai_cron.sh -j 26
5   6 * * *    yourwebsite    /home/yourwebsite/wpai_cron.sh -j 27
10  6 * * *    yourwebsite    /home/yourwebsite/wpai_cron.sh -j 28

# Run product imports every morning at 6 am

0 6 * * * yourwebsite /home/yourwebsite/wpai_cron.sh -j 26

5 6 * * * yourwebsite /home/yourwebsite/wpai_cron.sh -j 27

10 6 * * * yourwebsite /home/yourwebsite/wpai_cron.sh -j 28

WooCommerce: remove empty SKU products

Posted on November 21, 2014 by rolandow

At work, we got ourselves a nice WooCommerce shop. Using WP All Import, it automagically imports the products and updates stock. But somehow in we ended up with products in our database with no SKU.

Removing one of those products, and then rerun the import, seemed to work. So maybe these products where in the product feed once without a SKU. Who knows. Anyways, I wanted them gone, and didn’t want to delete the entire database, afraid of what Google may think of that.

So I checked the database a bit and came up with a SQL query. First, to check if you have products with empty SKU’s as well, you could run something like this:

   SELECT p.ID, 
	      p.post_title, 
	      p.post_type, 
	      pm.meta_value

     FROM wp_posts p

LEFT JOIN wp_postmeta pm
       ON pm.post_id = p.ID
      AND pm.meta_key = '_sku'

    WHERE p.post_type = 'product'
      AND (pm.meta_value = '' 
       OR pm.meta_value IS NULL)

SELECT p.ID,

p.post_title,

p.post_type,

pm.meta_value

FROM wp_posts p

LEFT JOIN wp_postmeta pm

ON pm.post_id = p.ID

AND pm.meta_key = '_sku'

WHERE p.post_type = 'product'

AND (pm.meta_value = ''

OR pm.meta_value IS NULL)

To remove the products, I think this should do. Of course this wouldn’t delete the files in your upload folder. If you want to delete those as well, you might want to write a script that selects the records, and then removes the images as well.

       DELETE wp_posts, 
       		  wp_postmeta,
       		  wp_comments,
       		  wp_commentmeta

         FROM wp_posts

	LEFT JOIN wp_postmeta
		   ON wp_postmeta.post_id = wp_posts.ID
          AND wp_postmeta.meta_key = '_sku'

    LEFT JOIN wp_comments
           ON wp_comments.comment_post_ID = wp_posts.ID

    LEFT JOIN wp_commentmeta
           ON wp_commentmeta.comment_id = wp_comments.comment_ID

    LEFT JOIN wp_postmeta wpm2
           ON wpm2.post_id = wp_posts.ID

		WHERE wp_posts.post_type = 'product'
  		  AND (wp_postmeta.meta_value= '' OR wp_postmeta.meta_value IS NULL)

DELETE wp_posts,

wp_postmeta,

wp_comments,

wp_commentmeta

FROM wp_posts

LEFT JOIN wp_postmeta

ON wp_postmeta.post_id = wp_posts.ID

AND wp_postmeta.meta_key = '_sku'

LEFT JOIN wp_comments

ON wp_comments.comment_post_ID = wp_posts.ID

LEFT JOIN wp_commentmeta

ON wp_commentmeta.comment_id = wp_comments.comment_ID

LEFT JOIN wp_postmeta wpm2

ON wpm2.post_id = wp_posts.ID

WHERE wp_posts.post_type = 'product'

AND (wp_postmeta.meta_value= '' OR wp_postmeta.meta_value IS NULL)

WP All Import cron from CLI

Posted on November 7, 2014 by rolandow

The WP All Import plugin can be used to import data from xml feeds. We use it in combination with WooCommerce. To automatically update your products and/or stock information, you should run this from a cron job. Unfortunately WP All Import didn’t do a very nice job on integrating this with the WordPress cron system, because I feel that the scheduling should be manager from your WordPress install instead of cronjob settings on the server.

WP All Import suggests that you set a cron job where you request an URL with wget. They already noticed a possible issue with this approach, which is timeouts. Therefore they created two actions: one to trigger the import, and a second one to process the import. When a timeout occurs, the process action should continue where it left of.

In our situation (nginx + php-fpm) this didn’t seem to work very well. The script was aborted after 30 seconds (which is what we have configured on the server ourselves), but when I re-requested the processing action, it said I should run the trigger action first. So, did the processing complete or not?

Since I don’t like running web requests from cron anyways, I searched for a method to run the import with PHP cli. This way we don’t have timeouts and the script will execute nicely. Also you can skip the “The processing URL should be run every two minutes because it may not finish your import in one run.” because it’s very unlikely that the script will timeout.

Enough chichat, here’s the line I added to /etc/cron.d/mywebshop:

0   6 * * *    webshop    cd /home/webshop/public_html; php -e -r 'parse_str("import_key=xxx&import_id=26&action=trigger", $_GET); include "wp-cron.php";' >/dev/null 2>&1; php -e -r 'parse_str("import_key=xxx&import_id=26&action=processing", $_GET); include "wp-cron.php";' >/dev/null 2>&1

1	0 6 * * * webshop cd /home/webshop/public_html; php -e -r 'parse_str("import_key=xxx&import_id=26&action=trigger", $_GET); include "wp-cron.php";' >/dev/null 2>&1; php -e -r 'parse_str("import_key=xxx&import_id=26&action=processing", $_GET); include "wp-cron.php";' >/dev/null 2>&1

Don’t forget to change the path to your WordPress install, and the import_key.

Rolandow's development blog

my external memory

Tag Archives: WooCommerce

WP All Import: calculate discounts using your own function

WP All Import cron from CLI (update)

WooCommerce: remove empty SKU products

WP All Import cron from CLI