Categories
View Replies (4)

Resolved VM Orders Import

  1. EsSa55
    EsSa55
  2. RO CSVI
  3. Wednesday, 06 January 2021
  4.  Subscribe via email
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
0
Responses (4)
EsSa55
EsSa55
Accepted Answer Pending Moderation
Hello Roland

Yes, that worked.

Thank you.

Best

Eddie
  1. more than a month ago
  2. RO CSVI
  3. # 1
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Eddie,

The format needs to be Y-m-d H:i:s which means Year-Month-Day Hour:Minute:Second. However it will also work if you just import Y-m-d/Year-Month-Day. As an example that would be 2020-12-30 or 2020-12-30 18:11:59.

Let me know if that helps.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 2
EsSa55
EsSa55
Accepted Answer Pending Moderation
Re order status, which field should I use?

Date Added Shopper Notified? Order Status Comment
Friday, 01 January 2021 00:00 No Unknown order status unknown


The orders table reports it as C(onfirmed) so is the above an unavailable field.table?

Best

Eddie
  1. more than a month ago
  2. RO CSVI
  3. # 3
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Eddie,
Re order status, which field should I use?

You can use order_status_name field for order status name and order_status or order_status_code for code. In your case you can set order_status or order_status_code fields to 'C' on import.

Date Added Shopper Notified? Order Status Comment
Friday, 01 January 2021 00:00 No Unknown order status unknown

Please tell me where you see this message. Will be great if you can send a screenshot on this.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!