object
oriented
automation
 
php programmer
for webshops
and the web
 
15 years experience
hourly low rate
so payable
 
opencart magento prestashop
woocommerce (wordpress)
oscommerce virtuemart (joomla)
 
Nederlands (Dutch) English (Engels)
 
 
Object Oriented Automation
object oriented automation
php programmer for webshops and the web
15 years experience hourly low rate so payable
opencart magento prestashop oscommerce
woocommerce (wordpress) virtuemart (joomla)
Nederlands (Dutch) English (Engels)

Own modules or extensions for Magento, OpenCart etc.

(title page: OpenCart Offer Quotations module, Magento WebfileChecker extension ..)

Table of contents: (show / hide, click on number of section)


1.0 New (free) WebFileChecker module / extension for Magento (PostNL and OpenCart Offer extension / module see below) / also for OpenCart / Prestashop / Virtuemart / OsCommerce
2.0 New OpenCart Offer Quotations extension / module
2.1 New OpenCart extension / interface with shopping-cart or orders from Beslist.nl
3.0 Dutch PostNL module / extension for Magento (free) with letter logic

1.0  New (free) WebFileChecker module / extension for Magento / also for OpenCart / Prestashop / Virtuemart / OsCommerce / WooCommerce

Extension description ("Web File Checker"):

E.g. why is there an error suddenly, has somebody something changed or was there an automatic update from outside, what has a programmer modified, have you been hacked etc. (solution a Web File Checker). Check your webstore on modifications and configurations. Magento 1.x has about 15.000 files and 5000 directories, in Magento 2.x even more ..

Now (since 2016) for Magento free to download at Github for version 2.x!.

Now (since 2016) for Magento free to download at Github for version 1.x.. This version was for some years to download on Magento Connect.

Now (since 2016) also for other webshops free to download at Github.

No support unfortunately (too busy)!

Read the download page carefully because the installation asks for minimal technical skills!

For this extension cron jobs must already run (cron.php/.sh must run already) and you have enough time from your provider to run for at least 10 minutes (this varies for customers from 1 to 10 minutes for a slow server).

WebFileChecker module
F R E E
This module will be installed outside the core, so the Magento core can be updated for a next version without losing this module. This module works in all versions of Magento (also a version for 2.x is available).

This program runs every day 2x as cronjob at 07.00 and 15.00 (can be changed in config.xml).
It checks always which Magento files are modified since the last run. It also checks for changed configuration settings.
If modified you will receive a report per email, otherwise an empty email with subject. After the first run you receive all filenames and configuration settings (not really, more a link to your log the first time).
So you can check always what has modified (by someone or an update) e.g. to solve errors.
This program can also be called in between from the browser with {url}/index.php/{admin}/webfilechecker (if your provider gives you enough time, if you have Scheduler you may start a cronjob immediately). This is only possible when you log off first from your administration, during the call you need to login. This prevents WebFileChecker to be called via your webstore.
In the protected /var/wfc directory you can find the webfilechecks log with modifications on date. Or e.g. to clean this log after a long period.
Or click the button for viewing this log immediately (or {url}/index.php/{admin}/webfilechecker/view, first log off).
If you create a backup from these few files and later restore, you can determine the changes always again since your last backup! There are only 3 files in the protected /var/wfc directory: 1) ooa_wfc_ref.log (reference log files) 2) ooa_wfc_ref_conf.log (reference log configuration variables) 3) ooa_wfc_mod.log (changes compared to both reference logs). Through restoring 1) and 2) changes can be determined again. If you for example have been hacked, you can easily see which files have been modified!
Please don't touch the reference logs, these logs are necessary for comparisons in a next run.

Languages Dutch and English.

Extension support:

No support unfortunately (too busy).

Extension history:

Such a script was there already for OsCommerce (but more extensive). I tried then in 2013 to find such scripts for other webshops but nothing found. Then I found a snippet on the internet how you could easily determine if programs (files) were changed and used this for the WebFileChecker.
WebFileChecker Magento module
WebFileChecker Magento module

2.0  New OpenCart Offer Quotations extension / module

Extension description:

Offer Quotation OpenCart module
OpenCart Offer Quotations extension / module functioning just as and near the shopping cart, simple conversion of offer quotation in the admin to an order with some updates (OCMOD / VQMOD).

This is no instant module immediately working in every webshop without modifications. This module works but must be modified for all extensions (or parts) applicable on the shopping cart. In the admin order program quantities and amounts can be updated, also confirmation emails can be send for the order (offer) to the customer (also for the accepted offer). This must also join the eventually extensions applicable on the admin order program. The sales price of this module is 250 Euro ex. VAT + all working hours necessary to modify this module for your webshop. But the complete code is already invented, tested and live in a webshop!

Meanwhile there is also another version for which the order procedure have been converted to an offer, in the admin to convert again to an order and in My Account to accept. This version has lesser adaptations!

Meanwhile also another version for which the product have been converted immediately to an offer at which also own options and comments can be given. This version has even lesser adaptations!

For all these versions the offers are not saved separately in a second maintenance program avoiding double functionalities, but between the orders in the order maintenance program!

2.1  New OpenCart extension / interface with shopping-cart or orders from Beslist.nl

Extension description:

Beslist.nl interface OpenCart module
At Beslist.nl is the sales of own products from your web shop organized as next. Via the daily product feed, you deliver the prices incl. vat, and you deliver your shipping costs incl. vat per product. The sales orders from beslist.nl can be retrieved any moment via a xml api and returns near the sales products info also the transaction costs and commission which have to be payed to beslist.nl. All these amounts are taken up into the beslist.nl invoicing in which that transaction costs and commissions are deducted, and over the whole is 21% vat calculated which may be deducted again in your vat declaration.

For this extension you must have the possibility at your provider to run cronjobs!

This extension will be manually installed and cost 150 Euro ex. Vat!

This extension for OpenCart from version 2.2 (see at the bottom for other versions) have been organized as a cronjob which may run many times daily and have been programmed flexible as next:
  • settings for your connection data for the xml api from beslist.nl
  • settings for your api key able to create orders within your OpenCart version
  • settings to work with test orders from beslist.nl or to retrieve your real orders
  • settings for the order status used for your created beslist.nl orders
  • settings if the delivered product code in the feed to beslist.nl, is the product sequence number or the sku
  • settings (like the Vat % and name) for how your shipping method must be set in your orders
  • settings for which dummy zone id must be taken for NL and BE (these are unknown at beslist.nl and for some webshops mandatory)
  • options as size and color are not build in this extension, so must be built by request the first time and take working hours!
  • prices of products must be the same as in the webstore, because that prices are retrieved in the order api, customers are guests in the created orders
  • orders at beslist.nl can be retrieved only within a date range, therefore the cronjob retrieves the orders automatically for the current date and one day before, only orders are created which have not been processed yet
  • you get an email for the new order numbers
  • a new api orders function have been added to OpenCart because of the settings of shipping method, payment method used at beslist.nl, the transaction costs from beslist.nl and the commission from beslist.nl in your created orders
  • two new totals have been added in this extension for the transaction costs and the commission for which the Vat can be set according your choice
  • so one can chose to create orders only with product data, shipping method and payment method used by a customer at beslist.nl
  • or one can extend these orders with the settings of transaction costs and commission (incl. or excl. Vat) as negative amounts, so all data have been available for a eventually general ledger interface, a customer can’t see these orders, you have only to take care for the shipments. Comparing with your invoice from beslst.nl, there can always be a small difference in cents in the Vat calculation, this extension have not a solution for that, so you have to make an extra booking into your general ledger in that case or to use another solution.
  • price changes and delivery time changes are being communicated to beslist.nl per cronjob run

For versions 2.0 and 2.1 there must be created a modification for the login into the orders api within OpenCart, but probably also possible within this extension price. For older versions like 1.5 etc. the orders must be hard created into the database. This will be probably somewhat more expensive the very first time (purely working hours), afterwards the extension price will be the same again!

3.0  Dutch PostNL module / extension for Magento (free) with letter logic

Extension description:

Extension since 2011 successfully used in many Dutch webshops and has been maintained as soon as shipping policy changes at PostNL. Now with letterbox package in 2014.

Take care : PostNL have an own free module since the last years!

Now (since 2016) free to download at Github for version 2.x (as an coding example or as an usable shipment module)!

Now (since 2016) free to download (with Parcelware) at Github for version 1.x.. This version was for years to download on Magento Connect.

No support unfortunately (too busy)!

PostNL Magento module
F R E E
The interface with Parcelware - desktop/web can be included in this module (extension). Such an interface is only an excel sheet with shipping data which can be imported in Parcelware/Parcelweb. These days there is no feedback anymore via an excel sheet to the webshop (from Parcelware/Parcelweb). But with a own made program at Ooawebshops, it is still possible to import track&trace codes automatically in the webshop (not included in the price).

This module will be installed outside the core, so the Magento core can be updated for a next version without losing this module. This module works in all versions of Magento.

Everything can be set manually, so no rates will be get automatically from PostNL website. Below is written exactly what is built into the module. This module can also be the basis for another shipper with some changes.
Maybe the text can't be read very clear by everyone on the images below, the text from the first image is showed below. Sometimes you see the text TNTpost below but is replaced by PostNL. You get the module with the current rates (now 2014), other years you must change by yourself.

These are all possibilities for Dutch PostNL single post. Weights must here be filled in grams, heights in cm (for letters) and rates in Euro (all in 2 decimals). On the product pages you may fill in if a product must be send as letter or package, the product may be send with PostNL, and a seal bag must be used (at some options always included). And of course the height of a product, if this product can be send as a letter.
By request of a customer a choice has added how to calculate what fits in 1 envelope. The choices are with the height of a product (all products are mounted up in the letter, always correct) OR with the maximum quantity of a product what fits in a letter (take that spacious). In this last case it will be calculated as follows (sometimes the rate will be calculated too low if it does not fit) : e.g. product A max. 9, product B max. 3, product C max. 6, than 3xA + 1xB + 2xC would be possible qua volume (1/3 + 1/3 + 1/3 = 1) etc.
Rates must be entered as follows (max. weight):(rate),(max. weight)(rate),etc. Use for rates a decimal point (so no comma).
Take care: don\'t add the Netherlands to the countries below, the Netherlands is the country for which the national rates apply.
Multiple packages are also possible but not for speed service (higher the maximum weight is not healthy for your back). Multiple packages have all of course the same rate class.
All text can be changed in the language files (Dutch or English).
The logic of this module is as follows:
  • if at least one product on the shopping cart is 'no PostNL', the rates are not displayed
  • if the maximum box weight is set to lower 10000 grams, the rates are not displayed (calculated rates not efficient in that case)
  • if at least one product on the shopping cart is a 'package', the whole shipment is a 'package'
  • if the whole shipment is a 'letter' and the weight is greater than the maximum weight of a normal letter, the whole shipment is a 'package'
  • if the whole shipment is a 'letter' and the height is greater than the maximum height of a normal letter, the whole shipment is a 'package'
  • if not one 'letter' shipment is enabled, the whole shipment is a 'package' in case it is a 'letter' shipment
  • a rate class option is not displayed if the weight is greater than the maximum weight for that rate class option AND no multiple boxes are allowed/enabled for that option
  • all rates can be showed or only the cheapest from all possibilities
  • if a COD option is chosen, only the payment modules 'COD' are displayed (if installed, otherwise all; e.g. Cash On Delivery is a COD module)

VAT shipping-options is based on show VAT yes/no and country shipping-address. Do you want VAT for all EU countries, enter for each EU country the VAT rate in the admin.

Speed service rates foreign countries (NL 12 hours included) not really updated since price updates Aug. 2013 (rates divided over 9 new zones), because almost never used in a webshop. By request to build in.

Extension support:

No support unfortunately (too busy) for this free Magento 1.x and 2.x version!

PostNL Magento module


PostNL Magento module


PostNL Magento module


PostNL Magento module


PostNL Magento module


PostNL Magento module


PostNL Magento module


PostNL Magento module


PostNL Magento module


PostNL Magento module


PostNL Magento module


PostNL Magento module


PostNL Magento module


PostNL Magento module


PostNL Magento module


PostNL Magento module


PostNL Magento module


PostNL Magento module


PostNL Magento module