Archives Knowledge Base

View Consolidated Profits

If you have multiple sites running ApeksOPS and you would like to view consolidated profits across all sites, follow these steps. Choose one of your sites to be the main site. This will be the site that you will use…

Product Meta Fields

ApeksOPS adds these meta fields to WooCommerce products: _prfi_quantityOnPurchaseOrders _prfi_avgUnitCost _prfi_lastPurchaseUnitCostIncTax _prfi_quantityOnPurchaseOrdersLessOversold _prfi_nextExpectedDeliveryDate

Modify Built-in Specs

This page lists all of the Built-in Specs. (NOTE: A Spec can specify a list/report, or a maintenance page but it can also select a data type. All functionality is encapsulated in a Spec of one kind or another –…

Customizing ApeksOPS

ApeksOPS offers extensive and powerful customization capabilities. A large proportion of ApeksOPS is written in Javascript. Most of the logic is encapsulated in Javascript files called “specs”. You can see all built-in spec code by looking in the ApeksOPS installation…

Inc Tax Versus Excel Tax

If you’ve configured ApeksOPS to allow you to enter purchase order prices exclusive of tax, you should import into the “LineItem.unitCostExclTaxFX” column instead of “LineItem.unitCostIncTaxFX”.

Cost Data

ApeksOPS is a multi-currency system and its records hold values both in the foreign currency and the local currency. For the purposes of import, you will only need to import the foreign value (ApeksOPS calculates the local value). For example,…

Read-Only Data

Exports contain all data, including read-only and calculated columns. You can remove these from your imports if you wish. If you leave read-only columns in, the import process will check that the values match what is in ApeksOPS. If the…

Adding New Records

To add new records, specify “[new]” in the “id” column. (In most cases you can simply leave the ID column out if you are just importing new records).