Hello
I am trying to import some test VM orders by csv.
Here is a sample from the log:
INSERT INTO `u84uz_virtuemart_orders` (`virtuemart_user_id`,`virtuemart_vendor_id`,`order_number`,`order_pass`,`invoice_locked`,`order_total`,`order_salesPrice`,`order_billTaxAmount`,`order_billDiscountAmount`,`order_discountAmount`,`order_tax`,`order_shipment`,`order_shipment_tax`,`order_payment`,`order_payment_tax`,`coupon_discount`,`coupon_code`,`order_discount`,`order_currency`,`order_status`,`user_currency_rate`,`payment_currency_rate`,`virtuemart_paymentmethod_id`,`virtuemart_shipmentmethod_id`,`delivery_date`,`order_language`,`ip_address`,`STsameAsBT`,`paid`,`paid_on`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('4053','1','28742449','p_ba57eb','0','19.5','0.00000','0.00000','0.00000','2.93','0.68','0','0','15.43','0.46','0.00','','0.00','52','Shipped','1','1.000000','0','','','en-GB','xxx.xxx.xxx.xx','0','0.00000','0000-00-00 00:00:00','01/01/2021','4053','2021-01-06 12:36:09','688','0000-00-00 00:00:00','0')
The issue is that the "created_on" field does not import and remains empty.
If the problem is the format of the created_on date, how do I extend it, to include the time, in a csv file?
TIA
Eddie
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!