php - Database design ideas for order review

Currently, we need to build an order review tool, which needs to review the information submitted by users from different places. If it passes, the points will be increased. If it fails, the points will not increase or decrease, and the audit record must also be saved.

天蓬老师 2017-05-31 10:34:21 0  1  636

Chinese translation of "Change checkout table order review section" in Woocommerce can be called "Modify Woocommerce checkout table order review section"

I followed our friend's solution to change the checkout order review section in Woocommerce, now I only need to edit the CSS of the information table after payment, in which file should I change the CSS of this table? I want it to be right aligned at the top of the page, I've tried using the selecto...

P粉904450959 2023-08-28 16:41:39 0  1  512

Add all order item SKUs to order number in Woocommerce

I have this code that adds the product name as a prefix to the order number via functions.php, but I want to change it to add the SKU. In addition, it would be better if the quantity of each SKU could be inserted at the same time. Something like: 2xSKUA_1xSKUB_Order Number Can anyone point me in the...

P粉707235568 2023-09-11 23:19:34 0  1  620

node - mongodb database design mongoose schema

Order table design in a trading scenario: Suppose there are four products. The order data of each product must have the same parts, such as: order number, order owner, order type, order status, order tracking timeline, and different products at the same time. Orders also have their own special data....

扔个三星炸死你 2017-06-16 09:19:06 0  3  1091

javascript - vuejs+elementui shopping cart price calculation, click the plus or minus sign to modify the quantity and the total price will not change, but the calculation is executed

The function of placing an order for a product finds all the products, clicks to place the order, and then adds the ordered products to the shopping cart. The shopping cart does not need to save the products. You can modify the quantity and calculate the total price. Now the calculation in my method...

巴扎黑 2017-07-05 10:58:23 0  2  1319

Show order ID and order date in WooCommerce My Account download page.

I want to display the order ID, order date and product image in my account download page. This can be achieved using the following code: add_filter('woocommerce_account_downloads_column_download-product','display_product_image_on_account_downloads');function display_product_image_on_account_downl

P粉330232096 2023-07-27 13:10:51 0  1  455

In WooCommerce, display order details metadata in checkout confirmation emails and admin order pages

We have a number of products that are defined as "kits". They are product lists made up of other products. The data defining the suite is stored in the metadata array. I've created a hook to display metadata in the product page and shopping cart. I need to do something similar in the "...

P粉022140576 2023-08-15 12:06:40 0  1  493

Compare dates in SQL to rows from the same period last year.

I have a database that contains order dates, product codes, and customers, like this example: Index Code Customer Order Date 1 CCCC 2018-01-01 2 AAAA 2020-01-01 3 CCCC 2021-02-02 4 CCCC 2021-03-03 5DDDA 2022-04-04 6FFFF 202

P粉821231319 2023-08-02 22:49:52 0  1  737

javascript - How to get the values ​​in the input box looped out by v-for after clicking it and submit it

It's roughly like this. I'm currently working on an evaluation function that can evaluate multiple products in one order, but the interface can only interface with the submission of one product {code...} If I have 3 products, I want to know how to click a button. Just submit these 3 products togethe...

淡淡烟草味 2017-06-12 09:29:09 0  1  795

Sync by PivotTable ID instead of Model ID

I want to update order products by pivot id using sync method because in my scenario an order can have multiple products with the same id and I want to update the product whose pivot id I am calling and delete other products which I have not updated , but you know from the sync syntax that it accept...

P粉121447292 2024-02-17 15:02:30 0  1  503

Not sure why undefined variable notification trying to get product 'id'; when adding ACF field to custom column?

I have added a custom column to my WooCommerce product page in the admin dashboard, but when trying to populate the column by adding 2 custom ACF field settings for post type -> products, I receive the following error message about each product in it Debug error notifications listed on custom col...

P粉450744515 2024-02-21 13:30:15 0  1  460

How does PHP handle the two-dimensional display and submission of colors and sizes in product management?

Dear friends, I recently encountered a problem with the color and size attributes of a product. For example, a product has two colors and three sizes. Product A has a color design [black, white] and a size design [S, M, L]. I want to click on it. The product list comes to the product details page, e...

P粉529965851 2023-06-12 12:01:22 0  1  719

"Adding custom buttons to reduce inventory: Adding new functionality to Woocommerce admin orders"

Need help updating my product inventory on WooCommerce manage orders page. I currently have some code that works, but it removes inventory from the wrong product. Does anyone know why? add_action('woocommerce_after_order_itemmeta','action_woocommerce_order_item_add_button',10,2);functionaction_wooco...

P粉029057928 2023-09-09 11:58:57 0  1  574

How to skip deeply nested properties in Vue's Composition API for reactive conversion?

In vue-composition-api: Using the reactive() method, I want to keep a part of the object as a reference. I have some products, belonging to a custom category: constchair=newProduct(...);//lotsofinformationineachproductconsttable=newProduct(...);//lotsofinformationineachproduct and the order referenc...

P粉044526217 2024-03-26 23:52:54 0  1  405

ruby - How to implement priority warehouse selection of receiving address and shipping warehouse in PHP

Today I will ask a technical question about the priority warehouse selection of products, delivery addresses and shipping warehouses. For example: The user purchased three products A, B, and C (it can be considered that the user purchased n SKU products, Each SKU has a corresponding quantity), we us...

怪我咯 2017-06-27 09:18:02 0  1  948

node.js - Use superagent to capture UTF-8 website garbled characters

I use superagent + cheerio to crawl *Dong's products, but the Chinese garbled response header returned is as follows. It is compressed by gzip, but it stands to reason that superagent will decompress *Dong's product address https://item.jd.com/5025518.html by default. I took the product title and th...

天蓬老师 2017-07-06 10:35:50 0  2  1425

mysql trigger problem

After looking at the triggers in the database, I thought, if the quantity inserted into an order table is greater than the product table, then the product table should be a negative number and should be restricted. But when I use before to limit, it cannot be executed. Can anyone help me see what is...

覃斌 2018-08-07 10:02:20 0  2  1282

php - Are there any shortcuts to doing OpenAPI?

Some businesses on the website need to be service-oriented, such as product ordering, app, H5, PC. If a product has any special functions or special attributes, three terminals must be maintained every time. , I want to make it an OpenAPI model, maintain a set of logic, and provide unified services ...

phpcn_u1582 2017-06-16 09:18:42 0  1  758

javascript - If a page has no data and has data, different content will be displayed. What should the front end do?

Question 1: For example, it is an order page. When I do not have an order, I display a picture to guide the user to choose the product of their choice. The content will only appear here after the user places an order and pays. I am using Vue to write the page, so I make virtual json data and then te...

巴扎黑 2017-05-19 10:22:17 0  2  400

There are multiple products under multiple categories. How to arrange them in a circular manner by category?

I now have two tables, a category table and a product table. There is a field in the product table to record which category it belongs to. Now I want to display multiple categories from top to bottom on one page. Each category displays its information below. After the products are displayed, the nex...

葫芦娃平衡盘 2018-11-08 18:01:20 0  1  1367