eCommerce
Webbutik
Vad den är till för
Store the data of an online shop: listings, shipping methods, discount codes and web orders with a fulfilment flow. Refunds need a manager and an approval. A storefront or other client reads and writes this data through the API.
Vad paketet gör och inte gör
An online shop: categories, product listings with translations, shipping methods, discount codes, web orders with lines and a fulfilment flow of pending, paid, shipped, delivered, cancelled and refunded. When the instance runs with the public site enabled, visitors browse the published listings and place orders without an account; the server prices every order from the published listing and never trusts the browser. Orders take stock off the listing at checkout, apply discount codes and tax rates on the server, and are paid by bank transfer, by card through Stripe Checkout or in a local demo mode; the payment record, the provider reference and refunds are kept with the order. Refunds need a human approval from a manager; agents may only propose them. Customer name, email and addresses are personal data and are never public. Needs the Products package.
Modulinformation
- Version:
0.5.0 - Utgivare: SpaceCorps
- Licens: AGPL-3.0-or-later
- Kräver kärna:
^0.2(aktuell kärna är 0.2.0) - Mognad: Beta
- Kategorier: Försäljning
Modeller
ecommerce_category
A group of listings shown together in the shop
Läsgrupp: ecommerce.user. Skrivgrupp: ecommerce.manager.
| Fält | Typ | Dataklass | Personuppgift | Grupp | Agenter ser | Beskrivning |
|---|---|---|---|---|---|---|
name | text | none | nej | ecommerce.user | i klartext | Category name shown in the shop |
slug | text | none | nej | ecommerce.user | i klartext | URL part of the category, lowercase with dashes |
description | text | none | nej | ecommerce.user | i klartext | Short text about the category |
sequence | number | none | nej | ecommerce.user | i klartext | Order among categories, lowest first |
published | bool | none | nej | ecommerce.user | i klartext | Whether the category is visible to shoppers |
ecommerce_listing
A product as it appears in the online shop
Läsgrupp: ecommerce.user. Skrivgrupp: ecommerce.manager.
| Fält | Typ | Dataklass | Personuppgift | Grupp | Agenter ser | Beskrivning |
|---|---|---|---|---|---|---|
product_id | ref → product | none | nej | ecommerce.user | i klartext | The product being sold online |
title | text | none | nej | ecommerce.user | i klartext | Title shown in the shop |
slug | text | none | nej | ecommerce.user | i klartext | URL part of the product page, lowercase with dashes |
summary | text | none | nej | ecommerce.user | i klartext | One or two sentences shown on product cards |
description | longtext | none | nej | ecommerce.user | i klartext | Description shown on the product page, in Markdown |
image | image | none | nej | ecommerce.user | i klartext | Main picture of the product (PNG, JPEG, WebP or GIF, up to 5 MiB; it is re-encoded and its metadata removed on upload) |
image_alt | text | none | nej | ecommerce.user | i klartext | Text that describes the main picture for people who cannot see it |
category_id | ref → ecommerce_category | none | nej | ecommerce.user | i klartext | The category the listing is shown under |
price | money | none | nej | ecommerce.user | i klartext | Shop price including tax (minor currency units, e.g. cents) |
compare_at_price | money | none | nej | ecommerce.user | i klartext | Previous price shown crossed out (minor currency units) |
currency | text | none | nej | ecommerce.user | i klartext | ISO 4217 currency code of the prices, for example EUR; empty means the shop currency from the instance settings |
sku | text | none | nej | ecommerce.user | i klartext | Stock keeping unit shown on the product page |
stock_policy | select (always_available, block_when_out, allow_backorder) | none | nej | ecommerce.user | i klartext | What happens when stock runs out: always_available, block_when_out, allow_backorder |
stock_quantity | number | none | nej | ecommerce.user | i klartext | Units on hand, used with the stock policy. Every order takes its units off at checkout, and a cancelled, expired or refunded order puts them back; correct it by hand after a stock count |
published | bool | none | nej | ecommerce.user | i klartext | Whether the listing is visible to shoppers |
ecommerce_listing_image
An extra picture of a listing for its gallery
Läsgrupp: ecommerce.user. Skrivgrupp: ecommerce.manager.
| Fält | Typ | Dataklass | Personuppgift | Grupp | Agenter ser | Beskrivning |
|---|---|---|---|---|---|---|
listing_id | ref → ecommerce_listing | none | nej | ecommerce.user | i klartext | The listing the picture belongs to; it is shown only while the listing is published |
image | image | none | nej | ecommerce.user | i klartext | The picture (PNG, JPEG, WebP or GIF, up to 5 MiB) |
alt | text | none | nej | ecommerce.user | i klartext | Text that describes the picture for people who cannot see it |
sequence | number | none | nej | ecommerce.user | i klartext | Order in the gallery, lowest first |
published | bool | none | nej | ecommerce.user | i klartext | Whether the picture is shown in the shop |
ecommerce_listing_translation
A listing translated into another language
Läsgrupp: ecommerce.user. Skrivgrupp: ecommerce.manager.
| Fält | Typ | Dataklass | Personuppgift | Grupp | Agenter ser | Beskrivning |
|---|---|---|---|---|---|---|
listing_id | ref → ecommerce_listing | none | nej | ecommerce.user | i klartext | The listing this translates |
lang | select (en, de, fr, pl, fi, sv, es) | none | nej | ecommerce.user | i klartext | Language of the translation: en, de, fr, pl, fi, sv or es |
title | text | none | nej | ecommerce.user | i klartext | Translated title |
summary | text | none | nej | ecommerce.user | i klartext | Translated card text |
description | longtext | none | nej | ecommerce.user | i klartext | Translated description in Markdown |
published | bool | none | nej | ecommerce.user | i klartext | Whether the translation is shown; it is only reachable while its listing is published |
ecommerce_shipping_method
A way of delivering orders with its price
Läsgrupp: ecommerce.user. Skrivgrupp: ecommerce.manager.
| Fält | Typ | Dataklass | Personuppgift | Grupp | Agenter ser | Beskrivning |
|---|---|---|---|---|---|---|
name | text | none | nej | ecommerce.user | i klartext | Name shown at checkout, for example Standard delivery |
carrier | text | none | nej | ecommerce.user | i klartext | Carrier that delivers, for example DHL |
price | money | none | nej | ecommerce.user | i klartext | Delivery price (minor currency units) |
free_over | money | none | nej | ecommerce.user | i klartext | Order total above which delivery is free (minor currency units); empty means never |
delivery_days | number | none | nej | ecommerce.user | i klartext | Usual number of days until delivery |
active | bool | none | nej | ecommerce.user | i klartext | Whether shoppers can choose it |
ecommerce_discount_code
A code a shopper enters at checkout for a reduction
Läsgrupp: ecommerce.user. Skrivgrupp: ecommerce.manager.
| Fält | Typ | Dataklass | Personuppgift | Grupp | Agenter ser | Beskrivning |
|---|---|---|---|---|---|---|
code | text | none | nej | ecommerce.user | i klartext | The code shoppers type, for example SPRING10 |
kind | select (percent, fixed) | none | nej | ecommerce.user | i klartext | Type of reduction: percent or fixed |
value | number | none | nej | ecommerce.user | i klartext | Reduction: basis points for percent (1000 is 10.00 percent), minor currency units for fixed |
starts_on | date | none | nej | ecommerce.user | i klartext | First day the code works (YYYY-MM-DD) |
ends_on | date | none | nej | ecommerce.user | i klartext | Last day the code works (YYYY-MM-DD) |
max_uses | number | none | nej | ecommerce.user | i klartext | How many times the code may be used in total; empty means unlimited |
used_count | number | none | nej | ecommerce.user | i klartext | How many times it has been used. The shop counts a use when the order is placed and gives it back when the order is cancelled or never paid |
minimum_order | money | none | nej | ecommerce.user | i klartext | Smallest order total the code applies to (minor currency units) |
per_customer_limit | number | none | nej | ecommerce.user | i klartext | How many times one customer (by email address) may use the code; empty means no limit |
category_id | ref → ecommerce_category | none | nej | ecommerce.user | i klartext | Only listings of this category get the reduction; empty means the whole order |
active | bool | none | nej | ecommerce.user | i klartext | Whether the code can be used |
ecommerce_discount_use
How many times one customer has used one discount code (the customer is kept as a hash, never as an email address)
Läsgrupp: ecommerce.manager. Skrivgrupp: ecommerce.manager.
| Fält | Typ | Dataklass | Personuppgift | Grupp | Agenter ser | Beskrivning |
|---|---|---|---|---|---|---|
code_id | ref → ecommerce_discount_code | none | nej | ecommerce.manager | i klartext | The discount code |
customer_hash | text | internal | ja | ecommerce.manager | maskerad | Hash of the customer's email address, so the per-customer limit can be checked without keeping the address here |
count | number | none | nej | ecommerce.manager | i klartext | Uses so far |
ecommerce_tax_rate
A tax rate the shop applies to listings, computed on the server
Läsgrupp: ecommerce.user. Skrivgrupp: ecommerce.manager.
| Fält | Typ | Dataklass | Personuppgift | Grupp | Agenter ser | Beskrivning |
|---|---|---|---|---|---|---|
name | text | none | nej | ecommerce.user | i klartext | Name shown on the order, for example VAT |
rate_bp | number | none | nej | ecommerce.user | i klartext | Rate in basis points: 1900 is 19.00 percent |
country | text | none | nej | ecommerce.user | i klartext | Two-letter country code (for example DE) of the delivery address this rate is for; empty means every country that has no rate of its own |
category_id | ref → ecommerce_category | none | nej | ecommerce.user | i klartext | Only listings of this category; empty means every listing (and delivery) |
included | bool | none | nej | ecommerce.user | i klartext | Whether listing prices already include this tax (the usual way in the EU). If not, the tax is added on top at checkout |
active | bool | none | nej | ecommerce.user | i klartext | Whether the rate is applied |
ecommerce_order
An order placed online
Läsgrupp: ecommerce.user. Skrivgrupp: ecommerce.user.
| Fält | Typ | Dataklass | Personuppgift | Grupp | Agenter ser | Beskrivning |
|---|---|---|---|---|---|---|
number | text | none | nej | ecommerce.user | i klartext | Order number shown to the shopper. Free text: packages cannot generate sequences; the public checkout makes a random one |
customer_email | text | internal | ja | ecommerce.user | maskerad | Email address of the shopper |
customer_name | text | internal | ja | ecommerce.user | maskerad | Name of the shopper |
customer_id | ref → party | none | nej | ecommerce.user | i klartext | The matching contact, once the shopper is known |
shipping_address | longtext | internal | ja | ecommerce.user | maskerad | Delivery address |
billing_address | longtext | internal | ja | ecommerce.user | maskerad | Billing address when different from delivery |
shipping_method_id | ref → ecommerce_shipping_method | none | nej | ecommerce.user | i klartext | The chosen way of delivery |
discount_code_id | ref → ecommerce_discount_code | none | nej | ecommerce.user | i klartext | The discount code used, if any |
discount_code | text | none | nej | ecommerce.user | i klartext | The code the shopper entered, as it is shown on the order |
discount_use_id | text | internal | ja | ecommerce.user | maskerad | Which per-customer use counter this order counted against, so it can be given back |
country | text | internal | ja | ecommerce.user | maskerad | Two-letter country code of the delivery address, which decides the tax rate |
tax_summary | longtext | none | nej | ecommerce.user | i klartext | The tax lines of the order as JSON: name, rate in basis points, whether included in the prices, amount |
stock_returned | bool | none | nej | ecommerce.user | i klartext | Set when the units of a cancelled, expired or refunded order were put back on the listings, so it happens once |
reserved_until | number | none | nej | ecommerce.user | i klartext | Unix time until which an unpaid order holds its stock; after that it is cancelled and the stock goes back |
payment_method | select (manual, stripe, fake) | none | nej | ecommerce.user | i klartext | How the shopper chose to pay: manual (bank transfer or invoice), stripe (card) or fake (demo) |
placed_on | date | none | nej | ecommerce.user | i klartext | Day the order was placed (YYYY-MM-DD) |
currency | text | none | nej | ecommerce.user | i klartext | ISO 4217 currency code, for example EUR |
subtotal | money | none | nej | ecommerce.user | i klartext | Sum of the lines at listing prices (minor currency units, computed by the shop at checkout) |
discount_total | money | none | nej | ecommerce.user | i klartext | Reduction from the discount code (minor currency units) |
shipping_total | money | none | nej | ecommerce.user | i klartext | Delivery charge (minor currency units) |
tax_total | money | none | nej | ecommerce.user | i klartext | All tax on the order, both the part included in the prices and the part added on top (minor currency units) |
total | money | none | nej | ecommerce.user | i klartext | Amount the shopper pays: lines, minus the discount, plus delivery, plus tax that was added on top (minor currency units) |
payment_reference | text | financial | ja | ecommerce.user | undanhållen | Reference from the payment provider; never a card number |
tracking_reference | text | none | nej | ecommerce.user | i klartext | Carrier tracking number |
access_token | text | secret | nej | ecommerce.user | undanhållen | Secret link token that lets the shopper who placed a public order see its confirmation page. Nobody can read it back |
state | select (pending, paid, shipped, delivered, cancelled, refunded) | none | nej | ecommerce.user | i klartext | Fulfilment status: pending, paid, shipped, delivered, cancelled, refunded |
ecommerce_order_line
One product line of a web order
Läsgrupp: ecommerce.user. Skrivgrupp: ecommerce.user.
| Fält | Typ | Dataklass | Personuppgift | Grupp | Agenter ser | Beskrivning |
|---|---|---|---|---|---|---|
order_id | ref → ecommerce_order | none | nej | ecommerce.user | i klartext | The order the line belongs to |
product_id | ref → product | none | nej | ecommerce.user | i klartext | The product ordered |
listing_id | ref → ecommerce_listing | none | nej | ecommerce.user | i klartext | The shop listing the line was ordered from |
description | text | none | nej | ecommerce.user | i klartext | Product text as it was when ordered |
quantity | number | none | nej | ecommerce.user | i klartext | Units ordered |
unit_price | money | none | nej | ecommerce.user | i klartext | Price per unit including tax (minor currency units) |
subtotal | money | none | nej | ecommerce.user | i klartext | Line total (minor currency units, entered not computed) |
discount_amount | money | none | nej | ecommerce.user | i klartext | Part of the order discount that falls on this line (minor currency units) |
tax_name | text | none | nej | ecommerce.user | i klartext | Name of the tax applied to this line |
tax_rate_bp | number | none | nej | ecommerce.user | i klartext | Tax rate of this line in basis points |
tax_amount | money | none | nej | ecommerce.user | i klartext | Tax on this line, included in the prices or added on top (minor currency units) |
ecommerce_payment
A payment for a web order: which provider, its reference, the amount and what became of it. The shop never sees card data
Läsgrupp: ecommerce.user. Skrivgrupp: ecommerce.manager.
| Fält | Typ | Dataklass | Personuppgift | Grupp | Agenter ser | Beskrivning |
|---|---|---|---|---|---|---|
order_id | ref → ecommerce_order | none | nej | ecommerce.user | i klartext | The order being paid |
provider | select (manual, stripe, fake) | none | nej | ecommerce.user | i klartext | Who takes the payment: manual (bank transfer or invoice), stripe (Stripe Checkout) or fake (local demo) |
external_id | text | financial | nej | ecommerce.user | undanhållen | The provider's reference for this payment, for example a Stripe Checkout Session id. Never a card number |
checkout_url | text | financial | nej | ecommerce.user | undanhållen | Where the shopper pays, kept so the payment page can send them back to it while the payment is open |
state | select (open, succeeded, failed, expired, cancelled, refunded) | none | nej | ecommerce.user | i klartext | Payment status: open (waiting for the shopper), succeeded, failed, expired, cancelled, refunded |
amount | money | none | nej | ecommerce.user | i klartext | Amount to pay, set by the server from the order (minor currency units) |
currency | text | none | nej | ecommerce.user | i klartext | ISO 4217 currency code of the amount |
refund_id | text | financial | nej | ecommerce.user | undanhållen | The provider's reference for the refund, once the payment was refunded |
refunded_amount | money | none | nej | ecommerce.user | i klartext | Amount returned to the shopper (minor currency units) |
event_ids | longtext | none | nej | ecommerce.user | i klartext | Ids of the provider events already applied, as JSON, so a repeated notification changes nothing |
Arbetsflöden
ecommerce_order
| Åtgärd | Flyttar | Vem får köra den | Godkännande |
|---|---|---|---|
ecommerce_order.mark_paid | state: pending → paid | ecommerce.user | nej |
ecommerce_order.ship | state: paid → shipped | ecommerce.user | nej |
ecommerce_order.deliver | state: shipped → delivered | ecommerce.user | nej |
ecommerce_order.cancel | state: pending → cancelled | ecommerce.user | nej |
ecommerce_order.refund | state: paid → refunded | ecommerce.manager | ja |
ecommerce_order.refund_delivered | state: delivered → refunded | ecommerce.manager | ja |
ecommerce_payment
| Åtgärd | Flyttar | Vem får köra den | Godkännande |
|---|---|---|---|
ecommerce_payment.mark_failed | state: open → failed | ecommerce.manager | nej |
ecommerce_payment.cancel | state: open → cancelled | ecommerce.manager | nej |
Behörighetsgrupper
Grupper som den här appen använder:
ecommerce.managerecommerce.user
Steg som kräver godkännande
Steg som en agent bara kan föreslå:
ecommerce_order.refundecommerce_order.refund_delivered
Vad agenter kan och inte kan göra
En agent kan läsa, söka, skapa och uppdatera poster i den här appen, och köra de åtgärder som inte kräver godkännande, inom behörighetsgrupperna för sin token.
Den kan bara föreslå de här stegen, och en person måste godkänna dem: ecommerce_order.refund, ecommerce_order.refund_delivered, ecommerce_category.delete, ecommerce_listing.delete, ecommerce_listing_image.delete, ecommerce_listing_translation.delete, ecommerce_shipping_method.delete, ecommerce_discount_code.delete, ecommerce_discount_use.delete, ecommerce_tax_rate.delete, ecommerce_order.delete, ecommerce_order_line.delete, ecommerce_payment.delete.
Personuppgifter maskeras som platshållare: ecommerce_discount_use.customer_hash, ecommerce_order.customer_email, ecommerce_order.customer_name, ecommerce_order.shipping_address, ecommerce_order.billing_address, ecommerce_order.discount_use_id, ecommerce_order.country.
De här fälten undanhålls helt från agenter: ecommerce_order.payment_reference, ecommerce_order.access_token, ecommerce_payment.external_id, ecommerce_payment.checkout_url, ecommerce_payment.refund_id.
Beroenden
Varje beroende anger vilka versioner det accepterar. Inbyggda appar versioneras med kärnan, så ett krav på en sådan kontrolleras mot kärnversionen.
När den här appen installeras från marknadsplatsen installeras även de beroenden som saknas, i en enda plan som du bekräftar en gång.
Installera
Installera den från appen Customize (Marknadsplats), eller från kommandoraden:
obop modules install-from ecommerceKräver en databas och administratörsbehörighet.