-- phpMyAdmin SQL Dump
-- version 4.9.5deb2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: May 12, 2022 at 03:21 PM
-- Server version: 8.0.28-0ubuntu0.20.04.3
-- PHP Version: 7.4.3

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `ecommerce_bottomline`
--

-- --------------------------------------------------------

--
-- Table structure for table `aa_import`
--

CREATE TABLE `aa_import` (
  `product_id` int NOT NULL,
  `merchandise_id` int DEFAULT NULL,
  `internal_code` varchar(13) DEFAULT NULL,
  `old_codes` text,
  `price` decimal(6,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `aa_import`
--

INSERT INTO `aa_import` (`product_id`, `merchandise_id`, `internal_code`, `old_codes`, `price`) VALUES
(3168, 3168, '000-0127-49', NULL, '39.59'),
(3210, 3210, '000-15735-001', NULL, '415.78'),
(3214, 3214, '000-10046-001', NULL, '25.73'),
(3217, 3217, '000-12202-001', NULL, '33.26'),
(3229, 3229, '000-10874-001', NULL, '65.32'),
(3241, 3241, '000-0099-93', NULL, '53.44'),
(3313, 3313, '000-0127-45', NULL, '122.75'),
(3322, 3322, '000-10392-001', NULL, '25.73'),
(3338, 3338, '000-10027-001', NULL, '28.70'),
(3361, 3361, '000-10028-001', NULL, '19.79'),
(3364, 3364, '000-10027-001', NULL, '28.70'),
(3370, 3370, '000-14082-001', NULL, '805.85'),
(3382, 3382, '000-0127-66', NULL, '40.58'),
(3407, 3407, '000-11518-001', NULL, '98.99'),
(3415, 3415, '000-0119-88', NULL, '32.65'),
(3462, 3462, '000-0119-86', NULL, '53.44'),
(3466, 3466, '000-0099-06', NULL, '25.73'),
(3488, 3488, '000-11307-001', NULL, '25.73'),
(3489, 3489, '000-0120-62', NULL, '118.78'),
(3496, 3496, '000-10606-001', NULL, '56.41'),
(3512, 3512, '000-00128-001', NULL, '43.55'),
(3515, 3515, '000-12612-001', NULL, '53.44'),
(3526, 3526, '000-0099-83', NULL, '30.68'),
(3539, 3539, '000-0127-51', NULL, '42.56'),
(3553, 3553, '000-11308-001', NULL, '19.79'),
(3562, 3562, '000-11010-001', NULL, '71.26'),
(3581, 3581, '000-10563-001', NULL, '50.47'),
(3591, 3591, '000-10614-001', NULL, '23.74'),
(3603, 3603, '000-0106-77', NULL, '148.48'),
(3615, 3615, '000-10052-001', NULL, '40.58'),
(3644, 3644, '000-10977-001', NULL, '287.09'),
(3651, 3651, '000-00129-001', NULL, '27.71'),
(3668, 3668, '000-10802-001', NULL, '306.89'),
(3771, 3771, '000-0119-79', NULL, '22.76'),
(3786, 3786, '000-11019-001', NULL, '46.52'),
(3790, 3790, '000-11517-001', NULL, '237.58'),
(3797, 3797, '000-11523-001', NULL, '118.78'),
(3825, 3825, '000-0119-31', NULL, '30.68'),
(3872, 3872, '000-0127-29', NULL, '53.44'),
(3910, 3910, '000-10977-001', NULL, '287.09'),
(3914, 3914, '000-11674-001', NULL, '772.18'),
(3936, 3936, '000-10979-001', NULL, '19.79'),
(3954, 3954, 'AA000224', NULL, '78.20'),
(3965, 3965, '000-10260-001', NULL, '87.11'),
(3979, 3979, '000-10050-001', NULL, '25.73'),
(3994, 3994, '000-0120-37', NULL, '118.78'),
(4002, 4002, '000-0106-72', NULL, '76.22'),
(4031, 4031, '000-11069-001', NULL, '25.73'),
(4078, 4078, '000-10976-001', NULL, '138.59'),
(4133, 4133, '000-10029-001', NULL, '306.89'),
(4157, 4157, '000-10976-001', NULL, '138.59'),
(4158, 4158, '000-10464-001', NULL, '32.65'),
(4190, 4190, '000-11047-002', NULL, '296.98'),
(4254, 4254, '000-0119-10', NULL, '69.29'),
(4257, 4257, '000-10977-001', NULL, '287.09'),
(4270, 4270, '000-10910-001', NULL, '61.37'),
(4306, 4306, 'AA000223', NULL, '36.62'),
(4307, 4307, '000-10976-001', NULL, '138.59'),
(4318, 4318, '000-0099-94', NULL, '53.44'),
(4347, 4347, '000-11522-001', NULL, '118.78'),
(4386, 4386, '000-10465-001', NULL, '32.65'),
(4424, 4424, '000-12366-001', NULL, '30.68'),
(4426, 4426, '000-12752-001', NULL, '108.89'),
(4436, 4436, '000-13313-001', NULL, '29.68'),
(7015, 7015, '000-12185-001', NULL, '1118.69'),
(7058, 7058, '000-10467-001', NULL, '14.83'),
(7074, 7074, '000-12316-001', NULL, '485.09'),
(7092, 7092, '000-12607-001', NULL, '673.19'),
(7093, 7093, '000-12186-001', NULL, '1673.09'),
(7124, 7124, '000-13334-001', NULL, '376.19'),
(7157, 7157, '000-12568-001', NULL, '356.38'),
(7211, 7211, 'PRE90', NULL, '24.74'),
(7227, 7227, '000-13287-001', NULL, '346.49'),
(7228, 7228, '000-12364-001', NULL, '445.48'),
(7238, 7238, '000-14841-001', NULL, '1468.16'),
(7247, 7247, '000-13714-001', NULL, '435.59'),
(7254, 7254, '000-13560-001', NULL, '2663.09'),
(7255, 7255, '000-12397-001', NULL, '653.38'),
(7258, 7258, '000-12188-001', NULL, '3910.49'),
(7269, 7269, '000-13559-001', NULL, '1554.29'),
(7270, 7270, '000-13289-001', NULL, '603.89'),
(7286, 7286, '000-14444-001', NULL, '1237.49'),
(7302, 7302, '000-13214-001', NULL, '1079.09'),
(7327, 7327, '000-12603-001', NULL, '65.32'),
(7342, 7342, '000-13285-001', NULL, '524.69'),
(7344, 7344, '000-13294-001', NULL, '524.69'),
(7361, 7361, '000-13609-001', NULL, '861.28'),
(7362, 7362, '000-14448-001', NULL, '821.69'),
(7363, 7363, '000-13250-001', NULL, '1653.29'),
(7368, 7368, '000-0127-30', NULL, '75.23'),
(7402, 7402, '000-12240-001', NULL, '25.73'),
(7408, 7408, '000-10756-001', NULL, '316.79'),
(7423, 7423, '000-14491-001', NULL, '366.29'),
(7430, 7430, '000-14492-001', NULL, '366.29'),
(7439, 7439, '000-13977-001', NULL, '32.65'),
(7455, 7455, '000-11519-001', NULL, '118.78'),
(7486, 7486, '000-13237-001', NULL, '1549.34'),
(7502, 7502, '000-14955-002', NULL, '1504.79'),
(7535, 7535, '000-13942-001', NULL, '148.48'),
(7550, 7550, '000-12728-001', NULL, '138.59'),
(7600, 7600, '000-11748-001', NULL, '1326.59'),
(7631, 7631, '000-13944-001', NULL, '346.49'),
(7648, 7648, '000-14013-001', NULL, '128.69'),
(7649, 7649, '000-14839-001', NULL, '1049.39'),
(7651, 7651, '000-14015-001', NULL, '148.48'),
(7674, 7674, '000-14013-001', NULL, '128.69'),
(7700, 7700, '000-12519-001', NULL, '15.83'),
(7704, 7704, 'AA000400', NULL, '29.68'),
(7713, 7713, '000-14414-001', NULL, '65.32'),
(7733, 7733, 'SIMKIT-1', NULL, '128.69'),
(7738, 7738, '000-14257-001', NULL, '801.88'),
(7752, 7752, '000-13889-001', NULL, '138.59'),
(7761, 7761, '000-14041-001', NULL, '35.62'),
(7762, 7762, '000-11020-001', NULL, '53.44'),
(7789, 7789, '000-13336-001', NULL, '2385.89'),
(7794, 7794, '000-13245-001', NULL, '1623.59'),
(7801, 7801, '000-14041-001', NULL, '35.62'),
(7807, 7807, '000-14041-001', NULL, '35.62'),
(7860, 7860, '000-14082-001', NULL, '805.85'),
(7878, 7878, '000-14028-001', NULL, '108.89'),
(7879, 7879, '000-14170-001', NULL, '23.74'),
(7890, 7890, '000-14176-001', NULL, '25.73'),
(7896, 7896, '000-12292-001', NULL, '178.18'),
(7928, 7928, '000-13335-001', NULL, '1623.59'),
(7933, 7933, '000-0124-61', NULL, '34.64'),
(7946, 7946, '000-10662-001', NULL, '19.79'),
(7950, 7950, '000-13296-001', NULL, '346.49'),
(7951, 7951, '000-0127-37', NULL, '108.89'),
(7961, 7961, '000-12602-001', NULL, '65.32'),
(7989, 7989, '000-14424-001', NULL, '2039.39'),
(7990, 7990, '000-14425-001', NULL, '2257.18'),
(7996, 7996, '000-14383-001', NULL, '712.78'),
(8023, 8023, '000-13963-001', NULL, '1138.49'),
(8044, 8044, '000-14173-001', NULL, '23.74'),
(8045, 8045, '000-14174-001', NULL, '23.74'),
(8046, 8046, '000-14175-001', NULL, '23.74'),
(8048, 8048, '000-13561-001', NULL, '841.49'),
(8049, 8049, '000-14419-001', NULL, '1663.18'),
(8061, 8061, 'RAM-T2-12V', NULL, '2078.98'),
(8073, 8073, '000-11749-001', NULL, '1653.29'),
(8123, 8123, '000-14413-001', NULL, '65.32'),
(8135, 8135, '000-14444-001', NULL, '1237.49'),
(8161, 8161, '000-14472-001', NULL, '504.88'),
(8162, 8162, '000-14471-001', NULL, '584.09'),
(8163, 8163, '000-14493-001', NULL, '257.39'),
(8168, 8168, '000-11599-001', NULL, '13.85'),
(8184, 8184, '000-0124-57', NULL, '33.65'),
(8191, 8191, '000-12568-001', NULL, '356.38'),
(8215, 8215, '000-13759-001', NULL, '65.32'),
(8229, 8229, '000-12568-001', NULL, '356.38'),
(8243, 8243, '000-12292-001', NULL, '178.18'),
(8276, 8276, '000-10760-001', NULL, '86.11'),
(8278, 8278, '000-14538-001', NULL, '2960.09'),
(8372, 8372, '000-10757-001', NULL, '97.01'),
(8421, 8421, '000-13946-001', NULL, '336.59'),
(8446, 8446, '000-15000-001', NULL, '772.18'),
(8467, 8467, '000-14818-001', NULL, '1267.19'),
(8548, 8548, '000-14069-001', NULL, '35.62'),
(8550, 8550, '000-14068-001', NULL, '35.62'),
(8594, 8594, '000-14382-001', NULL, '603.89'),
(8620, 8620, '000-13964-001', NULL, '910.79'),
(8663, 8663, '000-14029-001', NULL, '188.09'),
(8721, 8721, '000-14489-001', NULL, '395.99'),
(9131, 9131, '000-14172-001', NULL, '23.74'),
(9262, 9262, '000-15504-001', NULL, '346.49'),
(9308, 9308, '000-13613-001', NULL, '158.39'),
(9354, 9354, '000-15531-001', NULL, '692.99'),
(9357, 9357, '000-15518-001', NULL, '465.29'),
(9455, 9455, '000-14431-001', NULL, '3494.69'),
(9516, 9516, '000-15520-001', NULL, '554.39'),
(9701, 9701, '000-14476-001', NULL, '277.19'),
(9734, 9734, '000-14543-001', NULL, '2187.89'),
(9735, 9735, '000-14537-001', NULL, '2187.89'),
(9758, 9758, '000-13702-001', NULL, '32.65'),
(9792, 9792, '000-14540-001', NULL, '2187.89'),
(9797, 9797, '000-12749-001', NULL, '25.73'),
(9798, 9798, '000-13692-001', NULL, '34.64'),
(10022, 10022, '000-15527-001', NULL, '633.59'),
(10055, 10055, '000-12395-001', NULL, '1079.09'),
(10068, 10068, '000-12395-001', NULL, '1079.09'),
(10167, 10167, 'M-EW-Y200-MS', NULL, '153.25'),
(10177, 10177, '000-15693-001', NULL, '1326.59'),
(10283, 10283, '000-14430-001', NULL, '3375.89'),
(10485, 10485, '000-15405-001', NULL, '2801.69'),
(10486, 10486, '000-14536-001', NULL, '2573.99'),
(10487, 10487, '000-14380-001', NULL, '980.08'),
(10488, 10488, '000-15689-001', NULL, '1207.79'),
(10509, 10509, '000-13913-001', NULL, '900.89'),
(10564, 10564, '000-15407-001', NULL, '6920.08'),
(10565, 10565, '000-15405-001', NULL, '2801.69'),
(10633, 10633, '000-12396-001', NULL, '445.48'),
(10637, 10637, '000-11142-001', NULL, '653.38'),
(10780, 10780, '000-15736-001', NULL, '534.58'),
(10789, 10789, '000-13522-001', NULL, '65.32'),
(10831, 10831, '000-11460-001', NULL, '1603.78');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `aa_import`
--
ALTER TABLE `aa_import`
  ADD PRIMARY KEY (`product_id`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
