Find Jobs
Hire Freelancers

Shopping order sql insert bug fix

$10-30 USD

Concluído
Publicado há aproximadamente 10 anos

$10-30 USD

Pago na entrega
3 Issues to fix MULTIPLE PRODUCT CHECKOUT #[login to view URL] different prodcut (item_id) is sotred in a row as pending before chekout. once shopper completed checkout, the each product should be FOREACH and insert into ordered table as each diffrent row with its detail included other table’s data. But here only insert one product and needed to be fix. #[login to view URL] checkout, each item stock number should be decreased by the number of its purchased. #3. Add case of “Delete only purchased item in shopping cart if there is uncheckout item remains” to DELETE shopping cart WHERE ID=shopper DETAILS #1 example. Shopper is about to checkout 3 products in shopping cart and this is saved as pending as INSERT INTO `bx_pmt_ordres_pending` (`id`, `order_id`, `client_id`, `seller_id`, `item_type`, `items`, `amount`, `shp_amt`, `currency`, `b_currency`, `b_amount`, `b_shpamt`, `shp_type`, `provider`, `error_code`, `error_msg`, `txn_id`, `date`, `shp_id`) VALUES (460, '94VP2S55F98GR1VY', 5479, 5606, 'P', '5606_31_533_1:5606_31_531_1:5606_31_534_1', 934.5, 60, 'USD', 'USD', 934.5, 20, 'pp', 'paypal', '', '', '', '1395897518', 16); Once checkout has completed, below has inserted include table in blue but red row is missing. INSERT INTO `bx_pmt_ordres` (`id`, `pending_id`, `txn_id`, `client_id`, `seller_id`, `module_id`, `item_id`, `color`, `size`, `option`, `item_count`, `amount`, `shp_amount`, `option_amt`, `s_currency`, `s_amount`, `s_shpamt`, `s_optionamt`, `b_currency`, `b_amount`, `b_shpamt`, `b_optionamt`, `buyer_status`, `seller_status`, `tracking_code`, `seller_pmt_status`, `admin_pmt_status`, `date`) VALUES (222, 460, '', 5479, 5606, 31, 533, 'Black', 'M', 'no', 1, 934.5, 20, 0, 'USD', 934.5, 20, 0, 'USD', 934.5, 20, 0, 'n', 'n', '', 'n', 'n', '1395897550'); (222, 460, '', 5479, 5606, 31, 531, 'White', 'L', 'no', 1, 189.50, 20, 0, 'USD', 189.50, 20, 0, 'USD', 189.50, 20, 0, 'n', 'n', '', 'n', 'n', '1395897550'); (222, 460, '', 5479, 5606, 31, 534, 'Black', '4', 'no', 1, 690.0, 20, 0, 'USD', 690.0, 20, 0, 'USD', 690.0, 20, 0, 'n', 'n', '', 'n', 'n', '1395897550'); INSERT INTO `bx_store_product_files` (`id`, `author_id`, `entry_id`, `media_id`, `price`, `allow_purchase_to`, `hidden`, `color`, `size`, `store_type`, `stock_num`, `cond`) VALUES (531, 5606, 486, 0, '189.50', '4', 0, 'White', 'L', 'P', 2, 0), (533, 5606, 488, 0, '55.00', '4', 0, 'Black', 'M', 'P', 1, 0), (534, 5606, 489, 0, '690.00', '4', 0, 'Black', '4', 'P', 2, 0); #2 example. $updateStockSql = 'UPDATE bx_store_product_files SET stock_num=stock_num-'.$item_count.' WHERE id='.$item_id.' '; echo $updateStockSql;exit; mysql_query($updateStockSql) or die(mysql_error()); #3 example. only value in purple should be deleted INSERT INTO `bx_pmt_cart` (`client_id`, `items`) VALUES (5479, '177_31_510_1:177_31_509_1':5606_31_533_1:5606_31_531_1:5606_31_534_1); REQUIREMENTS PHP MYSQL skills YOUR IP ADDRESS for htaccess to allow access The project should be consider as completed only when checkout sql insert test clears below @each of products has confirmed as order as each ( inserted into different row ) m/payment/history/site/ @product stock number has decrease the number of purchased quantity @only purchased item(s) has deleted in shopping bag m/payment/history/site/
ID do Projeto: 5725448

Sobre o projeto

8 propostas
Projeto remoto
Ativo há 10 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
Hi daida, I will fix them for you. Please provide me more details of this project. (Such as web site URL, or source code of the shop...) Regards, Huy
$30 USD em 2 dias
5,0 (93 avaliações)
6,4
6,4
8 freelancers estão ofertando em média $61 USD for esse trabalho
Avatar do Usuário
Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks
$93 USD em 1 dia
4,8 (471 avaliações)
8,3
8,3
Avatar do Usuário
A proposal has not yet been provided
$126 USD em 3 dias
4,8 (71 avaliações)
6,7
6,7
Avatar do Usuário
Hello! You are taking tehse obviously from some notes sent to you from your client, as all these "blue,red,purple" references are totally "out of place" (not in sinc with what's been posted here) and having no visual reference at all, so if you copuld please at least provide teh full notes so I can assess the job properly. Also, these wxamples. This is teh SQL sattemets it's executing as is now? If yes, then they contradict what you explain as problem #1, so please clarify on this as well. In overall I don't expect setting up these to pose any problem once the tasks have been clarified on. I can start working on these as soon as you make teh decision to move forward, and have clarified upon the tasks. Kind Regards, Dobri
$20 USD em 0 dia
4,9 (176 avaliações)
6,2
6,2
Avatar do Usuário
A proposal has not yet been provided
$55 USD em 1 dia
5,0 (54 avaliações)
5,8
5,8

Sobre o cliente

Bandeira do(a) JAPAN
Bunkyoku, Japan
4,7
13
Método de pagamento verificado
Membro desde fev. 24, 2011

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.