instructions.txt 2.2 KB

123456789101112131415161718192021222324252627282930313233343536
  1. Write WordPress plugin called "studiou-wc-ord-print-statuses" in PHP, that extends WooCommerce plugin.
  2. Plugin will have following features:
  3. 1. Extends Order status aligned after status wc-processing:
  4. wc-to-print - Prepare to Printing
  5. wc-in-print - In Printing
  6. 2. Extends Order fields (add new fields):
  7. to-print-date (DateTime) - Prepare To Print Date
  8. in-print-date (DateTime) - In Print Date
  9. external-ref-ord-no (varchar) - External Order Number
  10. external-ref-ord-delivered (DateTime) - External Order Delivered
  11. 3. In screen WooCommerce/Orders in combo near "Search Order" button there will be allow to find orders by field external-ref-ord-no
  12. 4. In screen WooCommerce/Orders extends (add new options) combo-box Bulk Actions for actions:
  13. Prepare to Printing Export
  14. - export all selected orders by using custom sql "SELECT * FROM `vsu_orders_car_prod_qty_img`" to .csv file
  15. - set all selected order statuses to wc-to-print and set order field to-print-date to current date.
  16. Set Status to Prepare to Printing
  17. - set all selected order statuses to wc-to-print and set order field to-print-date to current date.
  18. Set Status to In Printing
  19. - set all selected order statuses to wc-in-print and set order field in-print-date to current date.
  20. 5. In screen WooCommerce/Orders overview grid add columns (at the end) for new fields to-print-date, in-print-date, external-ref-ord-no
  21. 6. In screen WooCommerce/Orders add button "Import InPrint protocol" that will do (after press):
  22. - Import .csv file from local disk.
  23. - Import file will have following columns: "Order No", "ExternalOrder", "ExternalOrderDate"
  24. - Distinct values from import file by column "Order No"
  25. - Update all Orders in database, defined by column "Order" No and set order status to wc-in-print and set field in-print-date to current date.
  26. 7. In screen WooCommerce/Orders add button "Import Delivered protocol" that will do (after press):
  27. - Import .csv file from local disk.
  28. - Import file will have following columns: "Order No"
  29. - Distinct values from import file by column "Order No"
  30. - Update all Orders in database, defined by column "Order" No and set order status to wc-completed and set field external-ref-ord-delivered to current date.