7
« on: October 21, 2019, 03:34:43 AM »
Yeah thank you. i investigate the balance and its a credit-store solution. But i need to begin the store giving credit for 100 to every new customer.
I found a way and its execute an script insert to database to all customer. But i have to see every time a customer is aprobe to execute this script. PLease tell if its another way:
INSERT INTO `bitnami_abantecart`.`ac_customer_transactions`
(`customer_transaction_id`,
`customer_id`,
`order_id`,
`created_by`,
`section`,
`credit`,
`debit`,
`transaction_type`,
`comment`,
`description`,
`date_added`,
`date_modified`)
VALUES
(4,
18,
0,
1,
1,
100.0000,
0.0000,
"Credit-Store",
"CREDIT-FROM-STORE",
"CREDIT-FROM-STORE",
current_timestamp(),
current_timestamp());