grocery-manager/db/2023-04-03

--
-- PostgreSQL database dump
--

-- Dumped from database version 13.8 (Debian 13.8-0+deb11u1)
-- Dumped by pg_dump version 13.8 (Debian 13.8-0+deb11u1)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: _normalize_product_name(text, text); Type: FUNCTION; Schema: public; Owner: das
--

CREATE FUNCTION public._normalize_product_name(product_name text, category_name text, OUT name text) RETURNS text
    LANGUAGE sql
    AS $$
SELECT CASE
	WHEN product_name ~* 'eggs' THEN 'Eggs'
	WHEN product_name = 'Beef Jerky' THEN product_name
	WHEN product_name ~* 'beef' THEN 'Beef'
	WHEN product_name ~* 'chicken' THEN 'Chicken'
	WHEN product_name ~* 'chocolate' THEN 'Chocolate'
	WHEN product_name = 'Tomato Fresh' THEN product_name
	WHEN product_name = 'Tomato Juice' THEN product_name
	WHEN product_name ~* 'tomato' THEN 'Tomato'
	WHEN product_name ~* 'rye' THEN 'Rye'
	WHEN category_name IN ('Sweetener', 'Sugar') THEN 'Sweetener'
	ELSE product_name 
END
$$;


ALTER FUNCTION public._normalize_product_name(product_name text, category_name text, OUT name text) OWNER TO das;

--
-- Name: convert_unit(text, text, text); Type: FUNCTION; Schema: public; Owner: das
--

CREATE FUNCTION public.convert_unit(p_from text, p_to text, p_product text, OUT p_factor numeric) RETURNS numeric
    LANGUAGE sql
    AS $$
WITH RECURSIVE chain(_from, _to, product_id, factor) AS (
  WITH conversions_unified AS (
    SELECT *
    FROM conversions_complex AS cc
    UNION
    SELECT c.id, c._from, c._to, NULL AS product_id, c.factor
    FROM conversions AS c
  )
  SELECT
    ARRAY[]::int[],
    (SELECT id FROM units WHERE name = p_from),
    (SELECT id FROM products WHERE name = p_product),
    1::numeric
  UNION
  SELECT
	c._from || CASE
      WHEN t._from = c._to
      THEN t._from
      ELSE t._to
    END,
    CASE
      WHEN t._from = c._to
	  THEN t._to
      ELSE t._from
    END,
    t.product_id,
    CASE
      WHEN t._from = c._to
      THEN c.factor*t.factor
    ELSE c.factor/t.factor
    END
  FROM chain c
  JOIN conversions_unified t
    ON ((
      t._from = c._to OR t._to = c._to
    ) AND (
        t.product_id = c.product_id OR
        t.product_id IS NULL OR c.product_id IS NULL
      )
    )
  WHERE (
    c.product_id = (SELECT id FROM products WHERE name = p_product) OR
	c.product_id IS NULL
  ) AND (
    NOT ARRAY[CASE
      WHEN t._from = c._to
      THEN t._to
      ELSE t._from
    END] <@ c._from
  )
)

SELECT factor AS p_factor
  FROM chain
  WHERE _to = (
    SELECT id FROM units WHERE name = p_to
  )
  ORDER BY COALESCE(array_length(_from, 1),0) ASC
  LIMIT 1
$$;


ALTER FUNCTION public.convert_unit(p_from text, p_to text, p_product text, OUT p_factor numeric) OWNER TO das;

--
-- Name: insert_category(text, text); Type: PROCEDURE; Schema: public; Owner: das
--

CREATE PROCEDURE public.insert_category(p_name text, "group" text)
    LANGUAGE sql
    AS $$
INSERT INTO groups(id, name) VALUES ((SELECT max(id)+1 FROM groups), CASE WHEN "group" IS NULL THEN (SELECT g.name FROM categories AS c JOIN groups AS g ON (group_id = g.id) WHERE c.name = p_name) ELSE "group" END) ON CONFLICT DO NOTHING;
INSERT INTO categories(id, name, group_id) VALUES((SELECT max(id)+1 FROM categories), p_name, CASE WHEN "group" IS NULL THEN (SELECT group_id FROM categories WHERE name = p_name) ELSE (SELECT id FROM groups WHERE name = "group") END) ON CONFLICT DO NOTHING;
$$;


ALTER PROCEDURE public.insert_category(p_name text, "group" text) OWNER TO das;

--
-- Name: insert_product(text, text, text); Type: PROCEDURE; Schema: public; Owner: das
--

CREATE PROCEDURE public.insert_product(name text, category text, "group" text DEFAULT NULL::text)
    LANGUAGE sql
    AS $$
CALL insert_category(category, "group");
INSERT INTO products(id, name, category_id) VALUES((SELECT max(id)+1 FROM products), name, (SELECT id FROM categories WHERE name = category)) ON CONFLICT DO NOTHING;
$$;


ALTER PROCEDURE public.insert_product(name text, category text, "group" text) OWNER TO das;

--
-- Name: insert_store(text, text); Type: PROCEDURE; Schema: public; Owner: das
--

CREATE PROCEDURE public.insert_store(p_name text, p_code text)
    LANGUAGE sql
    AS $$
INSERT INTO stores(id, name, code) VALUES ((SELECT max(id)+1 FROM stores), p_name, p_code);
$$;


ALTER PROCEDURE public.insert_store(p_name text, p_code text) OWNER TO das;

--
-- Name: insert_transaction(timestamp with time zone, text, text, numeric, text, numeric, text, boolean); Type: PROCEDURE; Schema: public; Owner: das
--

CREATE PROCEDURE public.insert_transaction(ts timestamp with time zone, store text, description text, quantity numeric, unit text, price numeric, product text, organic boolean DEFAULT false)
    LANGUAGE sql
    AS $$
INSERT INTO transactions (id, ts, store_id, description, quantity, unit_id, price, product_id, organic) VALUES ((SELECT max(id)+1 FROM transactions), ts at time zone 'utc', (SELECT id FROM stores WHERE name = store), description, quantity, (SELECT id FROM units WHERE name = unit), price, (SELECT id FROM products WHERE name = product), organic);
$$;


ALTER PROCEDURE public.insert_transaction(ts timestamp with time zone, store text, description text, quantity numeric, unit text, price numeric, product text, organic boolean) OWNER TO das;

--
-- Name: insert_unit(text); Type: PROCEDURE; Schema: public; Owner: das
--

CREATE PROCEDURE public.insert_unit(p_name text)
    LANGUAGE sql
    AS $$
INSERT INTO units(id, name) VALUES ((SELECT max(id)+1 FROM units), p_name);
$$;


ALTER PROCEDURE public.insert_unit(p_name text) OWNER TO das;

--
-- Name: insert_unit_conversion(text, text, numeric); Type: PROCEDURE; Schema: public; Owner: das
--

CREATE PROCEDURE public.insert_unit_conversion(p_from text, p_to text, p_factor numeric)
    LANGUAGE sql
    AS $$
INSERT INTO conversions(id, _from, _to, factor) VALUES (
  (SELECT szudzik_encode(f.id, t.id) FROM units f, units t WHERE f.name = p_from AND t.name = p_to),
  (SELECT id FROM units WHERE name = p_from),
  (SELECT id FROM units WHERE name = p_to),
  p_factor
);
$$;


ALTER PROCEDURE public.insert_unit_conversion(p_from text, p_to text, p_factor numeric) OWNER TO das;

--
-- Name: insert_unit_conversion(text, text, text, numeric); Type: PROCEDURE; Schema: public; Owner: das
--

CREATE PROCEDURE public.insert_unit_conversion(p_from text, p_to text, p_product text, p_factor numeric)
    LANGUAGE sql
    AS $$
INSERT INTO conversions_complex(id, _from, _to, product_id, factor) VALUES (
  (SELECT szudzik_encode(f.id, t.id) FROM units f, units t WHERE f.name = p_from AND t.name = p_to),
  (SELECT id FROM units WHERE name = p_from),
  (SELECT id FROM units WHERE name = p_to),
  (SELECT id FROM products WHERE name = p_product),
  p_factor
);
$$;


ALTER PROCEDURE public.insert_unit_conversion(p_from text, p_to text, p_product text, p_factor numeric) OWNER TO das;

--
-- Name: szudzik_encode(integer, integer, boolean); Type: FUNCTION; Schema: public; Owner: das
--

CREATE FUNCTION public.szudzik_encode(x integer, y integer, p_symmetric boolean DEFAULT true) RETURNS integer
    LANGUAGE sql IMMUTABLE PARALLEL SAFE
    AS $$
SELECT CASE WHEN x >= y
    THEN CASE WHEN p_symmetric THEN y + x * x ELSE x * x + x + y END
    ELSE x + y * y
END
$$;


ALTER FUNCTION public.szudzik_encode(x integer, y integer, p_symmetric boolean) OWNER TO das;

--
-- Name: transaction_price_per_unit(text); Type: FUNCTION; Schema: public; Owner: das
--

CREATE FUNCTION public.transaction_price_per_unit(p_unit text) RETURNS TABLE(ts timestamp without time zone, store text, description text, price_per_unit numeric, unit text, product text, category text, "group" text, organic boolean)
    LANGUAGE sql
    AS $$
SELECT ts, store, description, min(CASE WHEN p_unit = "to" AND "from" = unit THEN price /(quantity*factor) WHEN p_unit = "from" AND "to" = unit THEN price*factor/quantity WHEN p_unit = unit THEN price/quantity ELSE NULL END) AS price_per_unit, p_unit AS unit, product, category, "group", organic FROM transaction_view JOIN conversion_view ON ("from" = unit OR "to" = unit) WHERE "to" = p_unit OR "from" = p_unit GROUP BY ts, description, product, category, "group", store, organic; 
$$;


ALTER FUNCTION public.transaction_price_per_unit(p_unit text) OWNER TO das;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: categories; Type: TABLE; Schema: public; Owner: das
--

CREATE TABLE public.categories (
    id integer NOT NULL,
    name text NOT NULL,
    group_id integer NOT NULL
);


ALTER TABLE public.categories OWNER TO das;

--
-- Name: products; Type: TABLE; Schema: public; Owner: das
--

CREATE TABLE public.products (
    id integer NOT NULL,
    name text NOT NULL,
    category_id integer NOT NULL
);


ALTER TABLE public.products OWNER TO das;

--
-- Name: transactions; Type: TABLE; Schema: public; Owner: das
--

CREATE TABLE public.transactions (
    id integer NOT NULL,
    ts timestamp without time zone DEFAULT now() NOT NULL,
    description text NOT NULL,
    organic boolean DEFAULT false NOT NULL,
    quantity numeric NOT NULL,
    price numeric NOT NULL,
    unit_id integer NOT NULL,
    product_id integer NOT NULL,
    store_id integer NOT NULL
);


ALTER TABLE public.transactions OWNER TO das;

--
-- Name: category_over_year_month_breakdown_view; Type: VIEW; Schema: public; Owner: das
--

CREATE VIEW public.category_over_year_month_breakdown_view AS
 SELECT categories.name AS category,
    date_part('year'::text, (timezone('utc'::text, t.ts))::timestamp without time zone) AS year,
    date_part('month'::text, (timezone('utc'::text, t.ts))::timestamp without time zone) AS month,
    trunc(sum(t.price), 2) AS total_price
   FROM ((public.transactions t
     JOIN public.products ON ((t.product_id = products.id)))
     JOIN public.categories ON ((products.category_id = categories.id)))
  GROUP BY (date_part('year'::text, (timezone('utc'::text, t.ts))::timestamp without time zone)), (date_part('month'::text, (timezone('utc'::text, t.ts))::timestamp without time zone)), categories.name
  ORDER BY (date_part('year'::text, (timezone('utc'::text, t.ts))::timestamp without time zone)), (date_part('month'::text, (timezone('utc'::text, t.ts))::timestamp without time zone)), categories.name;


ALTER TABLE public.category_over_year_month_breakdown_view OWNER TO das;

--
-- Name: conversions_complex; Type: TABLE; Schema: public; Owner: das
--

CREATE TABLE public.conversions_complex (
    id integer NOT NULL,
    _from integer NOT NULL,
    _to integer NOT NULL,
    product_id integer NOT NULL,
    factor numeric NOT NULL
);


ALTER TABLE public.conversions_complex OWNER TO das;

--
-- Name: units; Type: TABLE; Schema: public; Owner: das
--

CREATE TABLE public.units (
    id integer NOT NULL,
    name text NOT NULL
);


ALTER TABLE public.units OWNER TO das;

--
-- Name: conversion_complex_view; Type: VIEW; Schema: public; Owner: das
--

CREATE VIEW public.conversion_complex_view AS
 SELECT conversions_complex.factor,
    l.name AS "from",
    r.name AS "to"
   FROM ((public.conversions_complex
     JOIN public.units l ON ((conversions_complex._from = l.id)))
     JOIN public.units r ON ((conversions_complex._to = r.id)));


ALTER TABLE public.conversion_complex_view OWNER TO das;

--
-- Name: conversions; Type: TABLE; Schema: public; Owner: das
--

CREATE TABLE public.conversions (
    id integer NOT NULL,
    _from integer NOT NULL,
    _to integer NOT NULL,
    factor numeric NOT NULL
);


ALTER TABLE public.conversions OWNER TO das;

--
-- Name: conversion_view; Type: VIEW; Schema: public; Owner: das
--

CREATE VIEW public.conversion_view AS
 SELECT conversions.factor,
    l.name AS "from",
    r.name AS "to"
   FROM ((public.conversions
     JOIN public.units l ON ((conversions._from = l.id)))
     JOIN public.units r ON ((conversions._to = r.id)));


ALTER TABLE public.conversion_view OWNER TO das;

--
-- Name: conversions_complex_id_seq; Type: SEQUENCE; Schema: public; Owner: das
--

CREATE SEQUENCE public.conversions_complex_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.conversions_complex_id_seq OWNER TO das;

--
-- Name: conversions_complex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: das
--

ALTER SEQUENCE public.conversions_complex_id_seq OWNED BY public.conversions_complex.id;


--
-- Name: groups; Type: TABLE; Schema: public; Owner: das
--

CREATE TABLE public.groups (
    id integer NOT NULL,
    name text NOT NULL
);


ALTER TABLE public.groups OWNER TO das;

--
-- Name: group_over_year_month_breakdown_view; Type: VIEW; Schema: public; Owner: das
--

CREATE VIEW public.group_over_year_month_breakdown_view AS
 SELECT groups.name AS "group",
    date_part('year'::text, (timezone('utc'::text, t.ts))::timestamp without time zone) AS year,
    date_part('month'::text, (timezone('utc'::text, t.ts))::timestamp without time zone) AS month,
    trunc(sum(t.price), 2) AS total_price
   FROM (((public.transactions t
     JOIN public.products ON ((t.product_id = products.id)))
     JOIN public.categories ON ((products.category_id = categories.id)))
     JOIN public.groups ON ((categories.group_id = groups.id)))
  GROUP BY (date_part('year'::text, (timezone('utc'::text, t.ts))::timestamp without time zone)), (date_part('month'::text, (timezone('utc'::text, t.ts))::timestamp without time zone)), groups.name
  ORDER BY (date_part('year'::text, (timezone('utc'::text, t.ts))::timestamp without time zone)), (date_part('month'::text, (timezone('utc'::text, t.ts))::timestamp without time zone)), groups.name;


ALTER TABLE public.group_over_year_month_breakdown_view OWNER TO das;

--
-- Name: stores; Type: TABLE; Schema: public; Owner: das
--

CREATE TABLE public.stores (
    id integer NOT NULL,
    name text NOT NULL,
    code character varying(5) NOT NULL
);


ALTER TABLE public.stores OWNER TO das;

--
-- Name: transaction_view; Type: VIEW; Schema: public; Owner: das
--

CREATE VIEW public.transaction_view AS
 SELECT (( SELECT timezone('utc'::text, t.ts) AS timezone))::timestamp without time zone AS ts,
    s.name AS store,
    t.description,
    t.quantity,
    u.name AS unit,
    t.price,
    p.name AS product,
    c.name AS category,
    g.name AS "group",
    t.organic,
    s.code
   FROM (((((public.transactions t
     JOIN public.stores s ON ((t.store_id = s.id)))
     JOIN public.units u ON ((t.unit_id = u.id)))
     JOIN public.products p ON ((t.product_id = p.id)))
     JOIN public.categories c ON ((p.category_id = c.id)))
     JOIN public.groups g ON ((c.group_id = g.id)));


ALTER TABLE public.transaction_view OWNER TO das;

--
-- Name: legacy_transaction_view; Type: VIEW; Schema: public; Owner: das
--

CREATE VIEW public.legacy_transaction_view AS
 SELECT (transaction_view.ts)::date AS ts,
    transaction_view.store,
    transaction_view.description,
    transaction_view."group",
    transaction_view.category,
        CASE
            WHEN transaction_view.organic THEN 'Org'::text
            ELSE ''::text
        END AS note,
    trunc(min(
        CASE
            WHEN ((conversion_view."to" = ANY (ARRAY['kg'::text, 'L'::text])) AND (conversion_view."from" = transaction_view.unit)) THEN (transaction_view.quantity * conversion_view.factor)
            WHEN ((conversion_view."from" = ANY (ARRAY['kg'::text, 'L'::text])) AND (conversion_view."to" = transaction_view.unit)) THEN (transaction_view.quantity / conversion_view.factor)
            WHEN (transaction_view.unit = ANY (ARRAY['kg'::text, 'L'::text])) THEN transaction_view.quantity
            WHEN (transaction_view.unit <> ALL (ARRAY['mL'::text, 'L'::text, 'g'::text, 'kg'::text])) THEN transaction_view.quantity
            ELSE NULL::numeric
        END), 3) AS quantity,
        CASE
            WHEN (transaction_view.unit = ANY (ARRAY['mL'::text, 'L'::text])) THEN 'L'::text
            WHEN (transaction_view.unit = ANY (ARRAY['g'::text, 'kg'::text])) THEN 'kg'::text
            ELSE transaction_view.unit
        END AS unit,
    trunc(transaction_view.price, 2) AS price,
    transaction_view.product
   FROM (public.transaction_view
     LEFT JOIN public.conversion_view ON (((transaction_view.unit = conversion_view."from") OR (transaction_view.unit = conversion_view."to"))))
  GROUP BY transaction_view.ts, transaction_view.store, transaction_view.description, transaction_view."group", transaction_view.category, transaction_view.price, transaction_view.product, transaction_view.organic, transaction_view.unit
  ORDER BY transaction_view.ts, transaction_view.store, transaction_view.description, transaction_view."group", transaction_view.category, transaction_view.price, transaction_view.product, transaction_view.organic, transaction_view.unit;


ALTER TABLE public.legacy_transaction_view OWNER TO das;

--
-- Name: legacy_transaction_with_period_view; Type: VIEW; Schema: public; Owner: das
--

CREATE VIEW public.legacy_transaction_with_period_view AS
 SELECT (((((transaction_view.ts)::date - ((date_part('year'::text, transaction_view.ts) || '-04-01'::text))::date) / 7) / 4) + 1) AS period,
    (((((transaction_view.ts)::date - ((date_part('year'::text, transaction_view.ts) || '-04-01'::text))::date) / 7) % 4) + 1) AS period_week,
    (transaction_view.ts)::date AS ts,
    transaction_view.store,
    transaction_view.description,
    transaction_view.product,
    transaction_view.category,
    transaction_view."group",
        CASE
            WHEN transaction_view.organic THEN 'Org'::text
            ELSE ''::text
        END AS note,
    trunc(min(
        CASE
            WHEN ((conversion_view."to" = ANY (ARRAY['kg'::text, 'L'::text])) AND (conversion_view."from" = transaction_view.unit)) THEN (transaction_view.quantity * conversion_view.factor)
            WHEN ((conversion_view."from" = ANY (ARRAY['kg'::text, 'L'::text])) AND (conversion_view."to" = transaction_view.unit)) THEN (transaction_view.quantity / conversion_view.factor)
            WHEN (transaction_view.unit = ANY (ARRAY['kg'::text, 'L'::text])) THEN transaction_view.quantity
            WHEN (transaction_view.unit <> ALL (ARRAY['mL'::text, 'L'::text, 'g'::text, 'kg'::text])) THEN transaction_view.quantity
            ELSE NULL::numeric
        END), 3) AS quantity,
        CASE
            WHEN (transaction_view.unit = ANY (ARRAY['mL'::text, 'L'::text])) THEN 'L'::text
            WHEN (transaction_view.unit = ANY (ARRAY['g'::text, 'kg'::text])) THEN 'kg'::text
            ELSE transaction_view.unit
        END AS unit,
    trunc(transaction_view.price, 2) AS price,
    sum(transaction_view.price) OVER (PARTITION BY (((((transaction_view.ts)::date - ((date_part('year'::text, transaction_view.ts) || '-04-01'::text))::date) / 7) / 4) + 1) ORDER BY transaction_view.ts, transaction_view.description ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS running_total
   FROM (public.transaction_view
     LEFT JOIN public.conversion_view ON (((transaction_view.unit = conversion_view."from") OR (transaction_view.unit = conversion_view."to"))))
  GROUP BY (((((transaction_view.ts)::date - ((date_part('year'::text, transaction_view.ts) || '-04-01'::text))::date) / 7) / 4) + 1), transaction_view.ts, transaction_view.store, transaction_view.description, transaction_view."group", transaction_view.category, transaction_view.price, transaction_view.product, transaction_view.organic, transaction_view.unit
  ORDER BY (((((transaction_view.ts)::date - ((date_part('year'::text, transaction_view.ts) || '-04-01'::text))::date) / 7) / 4) + 1), transaction_view.ts, transaction_view.store, transaction_view.description, transaction_view."group", transaction_view.category, transaction_view.price, transaction_view.product, transaction_view.organic, transaction_view.unit;


ALTER TABLE public.legacy_transaction_with_period_view OWNER TO das;

--
-- Name: legacy_transaction_with_period_and_mode_view; Type: VIEW; Schema: public; Owner: das
--

CREATE VIEW public.legacy_transaction_with_period_and_mode_view AS
 SELECT subq.mode,
    legacy_transaction_with_period_view.period,
    legacy_transaction_with_period_view.period_week,
    legacy_transaction_with_period_view.ts,
    legacy_transaction_with_period_view.store,
    legacy_transaction_with_period_view.description,
    legacy_transaction_with_period_view.product,
    legacy_transaction_with_period_view.category,
    legacy_transaction_with_period_view."group",
    legacy_transaction_with_period_view.note,
    legacy_transaction_with_period_view.quantity,
    legacy_transaction_with_period_view.unit,
    legacy_transaction_with_period_view.price,
    legacy_transaction_with_period_view.running_total
   FROM (public.legacy_transaction_with_period_view
     JOIN ( SELECT legacy_transaction_with_period_view_1.period,
            mode() WITHIN GROUP (ORDER BY (to_char((legacy_transaction_with_period_view_1.ts)::timestamp with time zone, 'month'::text))) AS mode
           FROM public.legacy_transaction_with_period_view legacy_transaction_with_period_view_1
          GROUP BY legacy_transaction_with_period_view_1.period) subq USING (period));


ALTER TABLE public.legacy_transaction_with_period_and_mode_view OWNER TO das;

--
-- Name: product_group_view; Type: VIEW; Schema: public; Owner: das
--

CREATE VIEW public.product_group_view AS
 SELECT g.name AS "group",
    c.name AS category,
    p.name AS product
   FROM ((public.products p
     JOIN public.categories c ON ((p.category_id = c.id)))
     JOIN public.groups g ON ((c.group_id = g.id)))
  ORDER BY g.name, c.name, p.name;


ALTER TABLE public.product_group_view OWNER TO das;

--
-- Name: transaction_rollup_view; Type: VIEW; Schema: public; Owner: das
--

CREATE VIEW public.transaction_rollup_view AS
 SELECT ((((legacy_transaction_view.ts - ((date_part('year'::text, legacy_transaction_view.ts) || '-04-01'::text))::date) / 7) / 4) + 1) AS period,
    ((((legacy_transaction_view.ts - ((date_part('year'::text, legacy_transaction_view.ts) || '-04-01'::text))::date) / 7) % 4) + 1) AS week,
    (((date_part('year'::text, legacy_transaction_view.ts) || '-04-01'::text))::date + ((((legacy_transaction_view.ts - ((date_part('year'::text, legacy_transaction_view.ts) || '-04-01'::text))::date) / 7) / 4) * 28)) AS period_start,
    ((((date_part('year'::text, legacy_transaction_view.ts) || '-04-01'::text))::date + ((((legacy_transaction_view.ts - ((date_part('year'::text, legacy_transaction_view.ts) || '-04-01'::text))::date) / 7) / 4) * 28)) + 27) AS period_end,
    legacy_transaction_view."group",
    sum(legacy_transaction_view.price) AS sum
   FROM public.legacy_transaction_view
  GROUP BY (((legacy_transaction_view.ts - ((date_part('year'::text, legacy_transaction_view.ts) || '-04-01'::text))::date) / 7) / 4), (((legacy_transaction_view.ts - ((date_part('year'::text, legacy_transaction_view.ts) || '-04-01'::text))::date) / 7) % 4), (((date_part('year'::text, legacy_transaction_view.ts) || '-04-01'::text))::date + ((((legacy_transaction_view.ts - ((date_part('year'::text, legacy_transaction_view.ts) || '-04-01'::text))::date) / 7) / 4) * 28)), legacy_transaction_view."group"
  ORDER BY (((date_part('year'::text, legacy_transaction_view.ts) || '-04-01'::text))::date + ((((legacy_transaction_view.ts - ((date_part('year'::text, legacy_transaction_view.ts) || '-04-01'::text))::date) / 7) / 4) * 28)), legacy_transaction_view."group";


ALTER TABLE public.transaction_rollup_view OWNER TO das;

--
-- Data for Name: categories; Type: TABLE DATA; Schema: public; Owner: das
--

COPY public.categories (id, name, group_id) FROM stdin;
1	Aromatics	1
2	Tubers	1
4	Prepared	2
5	Fruit	1
6	Canned Goods	3
7	Eggs	4
8	Fish	4
21	Misc	3
25	Butter	26
32	Veggies	1
34	Coconut Milk	3
35	Coffee	36
36	Chocolate	37
37	Beef	4
315	Organic	144
321	Ice Cream	37
324	Chicken	4
491	Milk	26
498	Condiments	499
1930	Soda	36
144	Tea	36
145	Cheese	26
146	Flour	2
147	Sugar	148
1931	Juice	36
546	Electrolytes	36
548	Water	36
549	Chips	2
555	Supplemental	558
556	Nuts	559
557	Bulk	2
559	Dried Fruit	559
561	Seeds	559
143	Baking	144
565	Bars	499
567	Cold	499
569	Whole	2
570	Legumes	559
1932	Frozen Fruit	1
697	Sweetener	3
1993	Oil	3
2007	Lamb	4
2218	Concentrate	36
2264	Conventional	558
2406	Fermented	26
2428	Biscuits	37
2762	Supplement	36
2768	Balls	499
2783	Dried Meat	4
2794	Snacks	499
2796	Powdered	26
3294	Frozen Veg	1
3310	Lettuce	1
\.


--
-- Data for Name: conversions; Type: TABLE DATA; Schema: public; Owner: das
--

COPY public.conversions (id, _from, _to, factor) FROM stdin;
5	1	2	1000
19	3	4	1000
\.


--
-- Data for Name: conversions_complex; Type: TABLE DATA; Schema: public; Owner: das
--

COPY public.conversions_complex (id, _from, _to, product_id, factor) FROM stdin;
51	7	2	1	166
\.


--
-- Data for Name: groups; Type: TABLE DATA; Schema: public; Owner: das
--

COPY public.groups (id, name) FROM stdin;
1	Produce
2	Grains
3	Staples
4	Fish, Meat, Eggs
13	bogus
26	Dairy
36	Drinks
37	Treats
144	Baking
148	Fermenting
499	Prepared
558	Spices
559	Dry Goods
1367	
\.


--
-- Data for Name: products; Type: TABLE DATA; Schema: public; Owner: das
--

COPY public.products (id, name, category_id) FROM stdin;
1	Onions	1
2	Potatoes	2
3	Crackers	4
4	Bananas	5
5	Tomato Paste	6
6	Free Range Eggs	7
7	Fish Fillets	8
8	Vinegar	21
9	Apples	5
10	Kumara	2
11	Mushrooms	1
12	Butter	25
13	Squash	32
14	Carrots	32
15	Coconut Cream	34
16	Coffee Beans	35
17	Whittakers Chocolate	36
18	Beef Mince	37
19	Chocolate Chips	143
20	Tulsi Tea	144
21	Vintage Cheese	145
22	Wholemeal Flour	146
23	White Sugar	147
24	Avocado	5
25	Capsicum	32
26	Butternut Squash	32
27	Apple Cider Vinegar	21
28	Vanilla	143
29	Whole Fish	8
30	Fish Heads	8
31	Mango	5
32	Beetroot	32
33	Ice Cream	321
34	Frozen Peas	32
35	Tasty Cheese	145
36	Whole Chicken	324
37	Raw Milk	491
38	Cream	491
39	Saurkraut	498
40	Parsnips	32
41	Canned Tomatoes	6
42	Organic Cheese	145
43	Fish Frames	8
44	Organic Chicken	324
45	Curry Paste	498
46	Cucumber	32
47	Ginger	1
48	Chicken Drumsticks	324
49	Garlic	1
50	Jalapenos Canned	6
51	Beef Chuck	37
52	Blade Steak	37
53	Coconut Water	546
54	Chicken Thighs	324
55	Water	548
56	Corn Chips	549
57	Canned Tuna	8
58	FR Chicken Thighs	324
59	Strawberries	5
60	Cabbage	32
61	Brewers Yeast	555
62	Almonds	556
63	Quinoa	557
64	Nutritional Yeast	555
65	Sultanas	559
66	Hemp Seeds	561
67	OSM bars	565
68	Starter	143
69	Coconut Yoghurt	567
70	White Flour	146
71	Brown Rice	569
72	Red Lentils	570
73	Mung Beans	570
74	Pumpkin Seeds	561
75	Salt	21
76	Pukka Tea	144
77	Honey	697
78	Dried Dates	559
79	FR Chicken Drumsticks	324
80	FR Chicken Mince	324
81	Chicken Mince	324
82	Peaches	5
83	Canned Salmon	8
84	Apricots	5
85	Plums	5
86	Watermelon	5
87	Colby Cheese	145
88	Brazil Nuts	556
89	Tomato Fresh	32
90	Marmite	498
91	Bars	565
92	Nut Bars	565
93	Mandarins	5
94	Broccoli	32
95	Cauliflower	32
96	Kiwifruit	5
97	Pears	5
98	Burger Patties	37
99	Tonic Water	1930
100	Tomato Juice	1931
101	Blueberries Frozen	1932
102	Strawberries Frozen	1932
103	Chicken Frames	324
104	Canned Peaches	6
105	Mayo	498
106	Eggplant	32
107	M&Ms Mini	36
108	Rye Flour	146
109	Mild Cheese	145
110	Beans Canned	6
111	Coconut Oil	1993
112	Candied Ginger	21
113	Olives Jar	6
114	Pasta	4
115	Lamb Shank	2007
219	Lamb Pieces	2007
116	Beef Sausages	37
117	Oranges	5
118	Lamb Mince	2007
119	Pinenuts	556
120	Chicken Thighs BL	324
121	Beef Stir Fry	37
122	Kelp	555
123	Buckwheat Groats	561
124	Wheat Berries	569
125	Coconut Desiccated	559
220	Cayenne Powder	2264
221	Herbal Tea	144
126	Sunflower Seeds	561
127	Fish Sauce	498
222	Cookie Pack	2428
128	Doritos	549
129	Smoked Salmon	8
130	Tomato Sauce	6
131	Seaweed	555
132	Hot Chilli	32
133	FR Chicken Whole	324
134	Chicken Nibbles	324
135	Soda Syrup	2218
136	Rooibos Tea	144
137	Beef Shin	37
138	Lamb Cubes	2007
139	Tumeric	1
140	Garam Masala	2264
141	Ginger Ground	2264
142	Paprika	2264
143	Baking Soda	143
144	Cacao Powder	143
145	Beef Scotch Fillet	37
146	Brown Lentils	570
147	Dry Peas	570
148	Meatballs	37
149	Potato Crisps	549
150	Mixed Fruit Frozen	1932
151	Beef Patties	37
152	Maple Syrup	697
153	Yoghurt Dairy	2406
154	Soup Refrigerated	567
155	Beef Roast	37
156	Soy Sauce	498
157	Oreo Cookies	2428
158	Hummus	567
159	Cornflour	143
160	Buns	4
161	Pizza Bases	4
162	Salami	37
163	Mozzarella Cheese	145
164	Whole Oats	569
165	Cinnamon, Ground	315
166	Demerara Sugar	143
167	Sugar, Coconut	147
168	French Lentils	570
169	Adzuki Beans	570
170	Chicken Stir Fry	324
171	Beetroot Canned	6
172	Celery	32
173	Alberts Eggs	7
174	Flax Seeds	561
175	Molasses	697
176	Chickpeas	570
177	Olive Oil	1993
178	Cookie Time	2428
179	Frozen Cherries	1932
180	Magnesium Fizz	2762
181	Frozen Pop	567
182	Snack Balls	2768
183	Olives Bag	2794
184	Jar of Chillis	6
185	Dried Figs	559
186	Beef Jerky	2783
187	Sunflower Oil	1993
188	Fruit Bars	2794
189	Dark Chocolate	36
190	Powdered Milk	2796
191	Canned Apricots	6
192	Courgettes	32
193	Kassori Methi	2264
194	Walnut	556
195	Oat Bars	2794
196	Rice Crackers	4
197	Ryecorn	569
198	Beef Topside	37
199	Salsa	498
200	Lamb Shoulder	2007
201	Feta	145
202	Peanuts	556
203	Puffed Rice	569
204	Chicken Tender	324
205	Corned Beef	37
206	Prunes	559
207	Orange Juice	1931
208	Arrowroot Powder	143
209	Mixed Nuts	556
210	Cashews	556
211	Monkfruit	697
212	Milk Standard	491
213	Brown Sugar	697
214	White Rice	569
215	Mutton Chops	2007
216	Frozen Green Beans	3294
217	Ginger Beer	1930
218	Salad Bag	3310
\.


--
-- Data for Name: stores; Type: TABLE DATA; Schema: public; Owner: das
--

COPY public.stores (id, name, code) FROM stdin;
29	iHerb	iHerb
26	Magic Fresh	MF
27	Backyard Jem	BJ
28	Miscellaneous	MISC
1	Countdown	CD
2	PaknSave	PnS
3	Healthpost	HP
4	Bin Inn	BI
5	Dreamview	DV
6	Co-op	CO
7	Gordonton Farm Shop	GFS
8	TOFS	TOFS
9	Seafood Bazaar	SB
10	Whatawhata Berry Farm	Farm
11	Taupiri Dairy	TD
12	Sarah Geerlings	PERSN
13	New World	NW
14	Farmers Market	FM
15	Four Square	FS
16	SummerGlow Apiaries	SG
17	Tonic Health	TH
18	New Save	NS
19	Gilmours	GIL
20	Warehouse	WH
21	Organic Nation	ON
22	Christchurch Food Show	CFS
23	Reduce to Clear	RTC
24	Scotsburn Farm	SF
25	Fruit King	FK
\.


--
-- Data for Name: transactions; Type: TABLE DATA; Schema: public; Owner: das
--

COPY public.transactions (id, ts, description, organic, quantity, price, unit_id, product_id, store_id) FROM stdin;
100	2021-08-19 01:08:00	Whittakers Block Cocoa Dark 72% 250g	f	750	12.90	2	17	1
109	2021-07-19 21:35:00	Macro Organic Tomatoes Diced NAS 400g	t	1200	4.50	2	41	1
111	2021-08-27 05:14:00	WW French Whole Beans 200g	f	200.00	5	2	16	1
125	2021-07-20 00:18:00	Mainland Cheese Organic 500g	t	500	10.39	2	42	2
132	2021-11-15 19:44:00	Whittakers Block Cocoa Dark 72% 250g	f	250	4.5	2	17	1
136	2021-11-15 19:44:00	Mainland Cheese Organic 500g	t	1000	21.20	2	42	1
140	2021-11-15 20:10:00	Mainland Cheese Organic 500g	t	500	10.39	2	42	2
142	2021-11-03 23:00:00	Snapper Frames	f	0.995	4.48	1	43	9
157	2021-11-23 00:42:00	Robert Harris Italian Roast Beans 200g	f	200.00	5	2	16	1
160	2021-11-23 00:42:00	Macro Organic Tomatoes Diced NAS 400g	t	800.00	3	2	41	1
163	2021-11-29 20:45:00	Garlic NZ	f	0.047	1.17	1	49	1
170	2021-11-29 20:45:00	Mainland Cheese Organic 500g	t	500	10.60	2	42	1
176	2021-11-22 23:00:00	Organic Beef Mince 90/10	t	0.4	11	1	18	8
182	2021-11-10 23:00:00	Organic Beef Mince 90/10	t	0.4	11.40	1	18	8
184	2021-11-10 23:00:00	Snapper Frames	f	0.684	3.08	1	43	9
186	2021-11-04 23:00:00	Snapper Frames	f	0.99	4.48	1	43	9
189	2021-10-30 23:00:00	Local Cabbage	f	1	5	7	60	7
190	2021-10-30 23:00:00	Good Bugs Ginger Ninja Kimchi	f	500.00	16.00	2	39	7
192	2021-08-05 00:00:00	Organic Beef Mince 90/10	t	0.4	11	1	18	8
195	2021-11-10 23:00:00	PYO Strawberries at Whatawhata Berry Farm	f	1.037	15.94	1	59	10
196	2021-08-05 00:00:00	Dreamview Cream 500mL	f	0.50	6.00	3	38	5
197	2021-08-08 00:00:00	Dreamview Raw Milk 1L	f	3	9	3	37	5
198	2021-08-08 00:00:00	Dreamview Cream 500mL	f	0.50	6.00	3	38	5
199	2021-08-16 00:00:00	Dreamview Cream 500mL	f	0.50	6.00	3	38	5
200	2021-08-16 00:00:00	Dreamview Raw Milk 1L	f	3	9	3	37	5
201	2021-08-23 00:00:00	Dreamview Raw Milk 1L	f	1	3	3	37	5
205	2021-12-04 23:11:00	Whittakers Block Cocoa Dark 72% 250g	f	500	9	2	17	2
212	2021-12-08 23:00:00	Tip Top Sundae Ice Cream 2 L	f	2	6.90	3	33	11
216	2021-12-12 22:19:00	Macro Free Range Chicken Thigh Fillet, Reduced	f	0.495	9.78	1	58	1
217	2021-12-12 22:19:00	Macro Free Range Chicken Thigh Fillet, Reduced	f	0.513	10.14	1	58	1
221	2021-12-12 22:19:00	Garlic NZ	f	0.017	0.49	1	49	1
222	2021-12-12 22:19:00	Fresh Ginger	f	0.232	3.94	1	47	1
224	2021-12-12 22:19:00	CD Cream 500mL	f	0.50	3.91	3	38	1
234	2021-12-12 22:19:00	Cucumber Telegraph	f	1.00	1.8	7	46	1
237	2021-10-09 23:00:00	Nutritional Yeast, 1 kg bag	t	1	47.83	1	64	6
238	2021-10-09 23:00:00	Sultanas, Bulk 2.5 kg bag	t	2.5	21.47	1	65	6
239	2021-10-09 23:00:00	Chocolate Chips, bulk 10 kg bag	t	3	78.75	1	19	6
241	2021-07-26 00:00:00	Jumbo Dozen Eggs from Dairy	f	860	5	2	6	11
242	2021-11-30 23:00:00	Bulk Red Lentils Ceres 3.5 kg bag	t	3.5	20.26	1	72	6
243	2021-11-30 23:00:00	Bulk Mung Beans Ceres 3.5 kg bag	t	1	7.72	1	73	6
244	2021-11-30 23:00:00	Bulk Pumpkin Seeds Ceres 3 kg bag	t	3	39.44	1	74	6
245	2021-11-30 23:00:00	Bulk Ceres Salt	t	1	2.93	1	75	6
246	2021-11-30 23:00:00	Licorice and Cinnamon Tea, Pukka 20 count box 40g NET	t	40	15.50	5	76	6
247	2021-07-17 00:00:00	Whittakers Block Dark Ghana 250g	f	500	9	2	17	2
249	2021-12-20 23:18:00	Value Honey Creamed Clover Blend 500g	f	0.5	5.49	1	77	2
251	2021-12-20 23:18:00	Pams Flour Wholemeal 1.5 kg	f	1.50	1.98	1	22	2
252	2021-12-20 23:18:00	Queens Diamond Pitted Dates 400g	f	400	2.19	2	78	2
254	2021-12-20 23:18:00	Value Rice Brown Long Grain 1 kg	f	1	2.09	1	71	2
255	2021-12-20 23:18:00	Whittakers Block Dark Ghana 250g	f	500	9	2	17	2
257	2021-12-20 23:18:00	Apples Braeburn	f	1.931	7.32	1	9	2
262	2021-12-20 23:18:00	Cucumber Telegraph	f	1.00	0.99	7	46	2
267	2021-12-20 23:18:00	Capsicum mixed bag 700g	f	0.7	2.99	1	25	2
269	2021-12-20 23:18:00	Lewis Road Creamery Organic Single Cream 300mL	f	0.3	3.99	3	38	2
271	2021-11-10 23:48:00	CD Prime Beef Mince Reduced	f	1	12.85	1	18	1
272	2021-11-10 23:48:00	WW Flour Wholemeal 1.5 kg	f	1.50	2	1	22	1
274	2021-11-10 23:48:00	Macro Organic Tomatoes Diced NAS 400g	t	1.2	4.5	1	41	1
276	2021-11-10 23:48:00	Capsicum Odd Bunch 750g	f	750	5	2	25	1
277	2021-11-03 23:13:00	Loose Avocado	f	2	2	7	24	1
278	2021-11-03 23:13:00	Capsicum Red NZ	f	2	3	7	25	1
280	2021-11-03 23:13:00	Macro Organic Apple 1 kg bag	t	1	4.5	1	9	1
281	2021-11-03 23:13:00	Mainland Cheese Vintage 500g	f	500	10.50	2	21	1
282	2021-11-03 23:13:00	Mainland Cheese Organic 500g	t	1000	21.20	2	42	1
286	2021-11-03 23:00:00	OSM bars chocolate 6 pieces 507g NET 	f	6	13.48	7	67	2
287	2021-11-03 23:00:00	Fresh Ginger	f	0.096	1.15	1	47	2
289	2021-11-03 23:00:00	Eclipse Cheese Tasty 1 kg	f	1	11.99	1	35	2
294	2021-11-11 01:02:00	Robert Harris Italian Roast Beans 240g	f	480.00	9.00	2	16	2
295	2021-11-11 01:02:00	Whittakers Block Cocoa Dark 72% 250g	f	500	9	2	17	2
296	2021-11-11 01:02:00	Avocado Small	f	4	4	7	24	2
298	2021-11-11 01:02:00	Cucumber Telegraph	f	1.00	1.99	7	46	2
301	2021-11-11 01:02:00	Apples Fuji Organic 1 kg bag	t	1	3.99	1	9	2
302	2021-11-11 01:02:00	Eclipse Cheese Tasty 1 kg	f	1.00	11.99	1	35	2
306	2021-12-27 03:50:00	Whittakers Block Cocoa Dark 72% 250g	f	500	9	2	17	2
308	2021-12-27 03:50:00	Cucumber Telegraph	f	1.00	1.49	7	46	2
312	2021-12-27 03:50:00	Kapiti Ice Cream Triple Chocolate 1L	f	1	9.89	3	33	2
313	2021-12-27 03:50:00	Eclipse Cheese Tasty 1 kg	f	1.00	13.99	1	35	2
314	2021-12-27 03:50:00	Pam's Cream 1L	f	1	7.57	3	38	2
319	2022-01-07 01:28:00	Macro Organic Tomatoes Diced NAS 400g	t	2000.00	7.5	2	41	1
320	2022-01-07 01:28:00	Exotic Food Red Curry Paste 220g	f	440.00	7.6	2	45	1
322	2022-01-07 01:28:00	Essentials French Whole Bean 200g	f	200	5	2	16	1
323	2022-01-07 01:28:00	Cucumber Telegraph	f	1.00	2	7	46	1
324	2022-01-07 01:28:00	Capsicum Odd Bunch 750g	f	750	4.5	2	25	1
326	2022-01-11 02:54:00	Pams Free Range Eggs Mixed Grade 12s	f	1746.00	15.87	2	6	2
1	2021-06-17 04:41:00	Onions brown loose	f	702	1.76	2	1	1
11	2021-06-22 22:59:00	Onions Brown loose	f	196	0.29	2	1	2
39	2021-06-30 23:20:00	Onions Brown Loose	f	0.786	1.01	1	1	2
40	2021-07-27 04:29:00	Onions Brown Loose	f	0.762	1.52	1	1	1
63	2021-08-05 05:33:00	Onions Brown	f	0.901	1.16	1	1	2
78	2021-08-11 23:07:00	Local Spray Free Onions	f	4	2	7	1	7
96	2021-08-19 01:56:00	Onions Brown	f	0.556	0.55	1	1	2
104	2021-07-19 21:35:00	Onions Brown Loose	f	0.577	1.44	1	1	1
147	2021-11-23 00:42:00	Onions Brown Loose	f	0.722	2.16	1	1	1
172	2021-11-29 20:45:00	Onion Odd Bunch bag 1.5 kg	f	1.5	3.50	1	1	1
215	2021-12-11 23:00:00	Sourdough starter with instructions	t	50	5	2	68	12
327	2022-01-11 02:54:00	Value Rice Brown Long Grain 1 kg	f	1	2.09	1	71	2
328	2022-01-11 02:54:00	Whittakers Block Cocoa Dark 72% 250g	f	500	9	2	17	2
2	2021-06-17 04:41:00	Potatoes washed loose	f	2.117	6.33	1	2	1
13	2021-06-22 23:31:00	Potato bag 2.5 kg Odd Bunch	f	2.5	4	1	2	1
77	2021-08-11 23:07:00	Local Spray Free Potatoes	f	3	8	1	2	7
115	2021-07-14 22:30:00	Onions Brown Loose	f	0.317	0.48	1	1	1
126	2021-11-15 19:44:00	Onions Brown Loose	f	0.922	2.31	1	1	1
171	2021-11-29 20:45:00	Organic Potato	t	2	6.99	1	2	1
188	2021-10-30 23:00:00	Local Spray Free Onions	f	4	2	7	1	7
265	2021-12-20 23:18:00	Onions Brown	f	1.731	3.44	1	1	2
331	2022-01-11 02:54:00	Apricots Fresh Loose	f	0.155	0.93	1	84	2
333	2022-01-11 02:54:00	Cucumber Telegraph	f	1.00	1.49	7	46	2
338	2022-01-11 02:54:00	Plums Black Loose	f	0.075	0.37	1	85	2
339	2022-01-11 02:54:00	Watermelon Red Whole 1ea	f	2.68	6.99	1	86	2
341	2022-01-11 02:54:00	Valumetric Colby Cheese 1kg	f	1	7.99	1	87	2
342	2021-10-22 00:02:00	Macro Free Range Chicken Drumsticks	f	1.104	12.14	1	79	1
343	2021-10-22 00:02:00	Macro Free Range Chiken Whole	f	1.608	14.47	1	36	1
346	2021-10-22 00:02:00	Garlic NZ	f	0.052	1.51	1	49	1
351	2021-10-22 00:02:00	Jeds Beans 200g	f	200	6	2	16	1
353	2021-10-22 00:02:00	WW Flour Wholemeal 1.5 kg	f	1.50	2	1	22	1
354	2021-10-22 00:02:00	Otaika Valley Size 7 12 pack	f	1488.00	15.60	2	6	1
355	2021-10-22 00:02:00	Avocado Loose	f	3	3	7	24	1
356	2021-10-22 00:02:00	Macro Brazil Nuts 250g	f	250	8.50	2	88	1
357	2021-10-22 00:02:00	Cucumber Telegraph	f	1.00	2.3	7	46	1
358	2021-10-22 00:02:00	Capsicum Loose	f	6	9.00	7	25	1
359	2021-10-22 00:02:00	Tomato Beekist Jelly Beans	f	250	4	2	89	1
361	2021-10-22 00:02:00	Mexicano Corn Chips Natural 300g	f	300	3.59	2	56	1
362	2021-10-22 00:02:00	Sanitarium Marmite 250g	f	250	3.50	2	90	1
366	2021-10-28 02:33:00	Whittakers Blk Dark Almond 62% 250g	f	250	5	2	17	1
367	2021-10-28 02:33:00	Capsicum Red NZ	f	1	1.5	7	25	1
369	2021-10-28 02:33:00	Countdown Free Range Sz 7 12pk	f	744	6.9	2	6	1
371	2021-10-31 01:06:00	Avalanche Franz Josef Beans 200g	f	200	4.5	2	16	2
372	2021-10-31 01:06:00	Nice Natural Roasted Nut Bar Chocolate 6s	f	6	0.99	7	92	2
374	2021-10-31 01:06:00	Whittakers Block Cocoa Dark 72% 250g	f	250	4.79	2	17	2
378	2021-12-31 03:00:00	Fres produce the Odd Bunch Mandarins 1kg	f	1	5.2	1	93	1
379	2021-12-31 03:00:00	Watties tomatoes roasted garlic and onion 400g	f	400	2.20	2	41	1
380	2021-12-31 03:00:00	CD Cream 1L	f	1	7.62	3	38	1
383	2021-12-31 03:00:00	Broccoli Fresh	f	1	3	7	94	1
384	2021-12-31 03:00:00	Cauliflower Fresh	f	1	3.99	7	95	1
385	2021-12-31 03:00:00	Cucumber Lebanese	f	1.00	1.5	7	46	1
386	2021-12-31 03:00:00	Cucumber Telegraph	f	1.00	1.8	7	46	1
387	2021-12-31 03:00:00	Garlic NZ	f	0.07	2.1	1	49	1
388	2021-12-31 03:00:00	Kiwifruit Green NZ	f	1.2	4.2	1	96	1
390	2021-12-31 03:00:00	Chinese Pears	f	0.3	1.5	1	97	1
392	2021-12-31 03:00:00	Capsicum Odd Bunch 750g	f	750.00	5	2	25	1
393	2021-12-31 03:00:00	Countdown Burger Patties Ultimate bbq beef steak 4pk	f	500	11	2	98	1
396	2021-12-31 03:00:00	Countdown Free Range Sz 7 12pk	f	1488.00	13.80	2	6	1
399	2021-12-31 03:00:00	Countdown Tonic Water 1.5L	f	3	2.6	3	99	1
400	2021-12-31 03:00:00	Keri premium Tomato Juice 1L	f	1	2.5	3	100	1
401	2021-12-31 03:00:00	Tongariro Natural Spring Water 5L	f	5.00	3.90	3	55	1
402	2021-12-31 03:00:00	Countdown frozen blueberries 1kg	f	1	9.5	1	101	1
403	2021-12-31 03:00:00	Countdown Frozen Strawberries 500g	f	0.5	5.5	1	102	1
404	2022-01-17 20:17:00	Chicken Frames by Weight	f	1.51	6.04	1	103	1
408	2022-01-17 20:17:00	Kiwifruit Green NZ	f	0.432	3.67	1	96	1
409	2022-01-17 20:17:00	Apricots Fresh Loose	f	0.382	2.29	1	84	1
410	2022-01-17 20:17:00	Watermelon Red Whole 1ea	f	2.04	5.10	1	86	1
411	2022-01-17 20:17:00	Killinchy Gold Choc Hazelnut 1L	f	1	9	3	33	1
412	2022-01-17 20:17:00	Beef Value Mince 82% 500g Reduced	f	1.5	19.86	1	18	1
413	2022-01-17 20:17:00	Countdown frozen blueberries 1kg	f	1.00	9.50	1	101	1
414	2022-01-17 20:17:00	Woodlands Free Range Size 6 10 pk	f	530	4.90	2	6	1
415	2022-01-17 20:17:00	WW Peach SLices in Fruit Juice 410g	f	820.00	3	2	104	1
416	2022-01-17 20:17:00	Macro Organic Tomatoes Diced NAS 400g	t	1600.00	6	2	41	1
417	2022-01-17 20:17:00	Macro Organic Whole Egg Mayo 440g	t	440	6.5	2	105	1
418	2022-01-17 20:17:00	WW Flour Wholemeal 1.5 kg	f	1.50	2	1	22	1
422	2022-01-17 20:17:00	Mexicano Corn Chips Natural 300g	f	300	3	2	56	1
424	2021-12-14 23:00:00	Rye flour at 20kg Co-op price	t	2.5	9	1	108	6
425	2021-12-14 23:00:00	Local Market Cabbage	f	1.00	3	7	60	14
426	2021-12-29 23:00:00	Rye flour at 20kg Co-op price	t	2	7.16	1	108	6
427	2022-01-09 23:00:00	Local Market Cabbage	f	3	9	7	60	14
428	2022-01-09 23:00:00	Rye flour at 20kg Co-op price	t	2	7.16	1	108	6
429	2022-01-12 23:00:00	Tongariro Natural Spring Water 15L	f	15.00	10.5	3	55	1
432	2021-10-23 23:00:00	Dreamview Raw Milk 1L	f	3	9	3	37	5
433	2021-10-16 23:00:00	Dreamview Raw Milk 1L	f	2	6	3	37	5
437	2022-01-24 21:21:00	Watermelon Red Whole	f	2.34	4.68	1	86	1
440	2022-01-24 21:21:00	Countdown Free Range Sz 7 12pk	f	1488.00	13.8	2	6	1
441	2022-01-24 21:21:00	Alpine Cheese Mild 1 kg	f	1	10.95	1	109	1
442	2022-01-24 21:21:00	Macro Organic Tomatoes Diced NAS 400g	t	2400.00	9	2	41	1
119	2021-07-14 22:30:00	Organic Potato	t	2	6.99	1	2	1
266	2021-12-20 23:18:00	Potatoes washed loose	f	1.246	2.85	1	2	2
337	2022-01-11 02:54:00	Onions Brown, 1 large	f	0.311	0.87	1	1	2
344	2021-10-22 00:02:00	Onions Brown Loose	f	1.047	2.62	1	1	1
420	2022-01-17 20:17:00	Onions brown 1.5 kg	f	1.5	4.99	1	1	1
443	2022-01-24 21:21:00	Macro Org Baked Beans in Tomato Sauce 420g	t	420	1.5	2	110	1
444	2022-01-24 21:21:00	Cucumber Green	f	1.00	2.5	7	46	1
445	2022-01-24 21:21:00	WW Flour Wholemeal 1.5 kg	f	1.50	2	1	22	1
446	2022-01-24 21:21:00	Mexicano Corn Chips Natural 300g	f	600.00	7.18	2	56	1
448	2022-01-31 23:40:00	Olivado Natural Coconut Cooking Oil 1L	t	1	10.50	3	111	1
450	2022-01-31 23:40:00	Macro Organic Tomatoes Diced NAS 400g	t	1200.00	4.5	2	41	1
452	2022-01-31 23:40:00	Tasti Crystal GInger 150g	f	150	4.5	2	112	1
453	2022-01-31 23:40:00	WW Black Sliced Olives 430g	f	430	3.2	2	113	1
454	2022-01-31 23:40:00	Doritos corn chips original 170g	f	170	2	2	128	1
455	2022-01-31 23:40:00	Macro Org Pasta Penne 500g	f	500	2.50	2	114	1
456	2022-01-31 23:40:00	Mexicano Corn Chips Natural 300g	f	600	4.90	2	56	1
457	2022-01-31 23:40:00	Loose Avocado	f	1	1.5	7	24	1
459	2022-02-01 00:24:00	Organic Beef Mince Lean 400g	t	0.4	12	1	18	8
460	2022-02-01 00:24:00	Organic Lamb Shanks	t	0.85	28.50	1	115	8
461	2022-02-01 00:24:00	Organic Beef Sausage Garlic & Parsley	t	6	12	7	116	8
463	2022-01-31 23:07:00	OSM bars chocolate 6 pieces 507g NET 	f	12	25.78	7	67	2
464	2022-01-31 23:07:00	Otaika Valley Size 7 12 pack	f	744	6.99	2	6	2
465	2022-01-31 23:07:00	Pams Flour Wholemeal 1.5 kg	f	1.50	1.98	1	22	2
466	2022-01-31 23:07:00	Pams Flour Wholemeal 1.5 kg	f	1.50	1.98	1	22	2
467	2022-01-31 23:07:00	Queens Diamond Pitted Dates 400g	f	400.00	2.1900	2	78	2
468	2022-01-31 23:07:00	Sealord Tuna inWater 185g	f	740.00	10.00	2	57	2
469	2022-01-31 23:07:00	Whittakers Block Cocoa Dark 72% 250g	f	500	9	2	17	2
473	2022-01-31 23:07:00	Capsicum Bag Misfitz 750g	f	750	3.99	2	25	2
474	2022-01-31 23:07:00	Short Cucumber	f	1.00	1.79	7	46	2
475	2022-01-31 23:07:00	Fresh Ginger	f	0.181	1.99	1	47	2
479	2022-01-31 23:07:00	Killinchy Gold Vanilla 1L	f	1	8.99	3	33	2
480	2022-01-31 23:07:00	Mainland Cheese Organic 500g	t	1000	20.78	2	42	2
481	2022-01-31 23:07:00	Mainland Cheese Vintage 500g	f	500	10.39	2	21	2
482	2022-01-31 23:07:00	Valumetric Colby Cheese 1kg	f	1.00	10.99	1	87	2
483	2022-02-22 00:35:00	Watermelon Whole	f	3.265	3.27	1	86	1
484	2022-02-22 00:35:00	Chicken Thigh Bonein, Conventional, Reduced	f	0.819	7.01	1	54	1
485	2022-02-22 00:35:00	Essentials Coconut Cream 400 mL	f	1600.00	4.8	4	15	1
487	2022-02-22 00:35:00	Capsicum Odd Bunch 750g	f	750	5	2	25	1
488	2022-02-22 00:35:00	Mainland Cheese Vintage 500g	f	500	11	2	21	1
489	2022-02-22 00:35:00	Mainland Cheese Organic 500g	t	500	11	2	42	1
490	2022-02-22 00:00:00	Avalanche Franz Josef Beans 200g	f	400	8	2	16	2
492	2022-02-22 00:00:00	Otaika Valley Size 7 12 pack	f	2976.00	26.36	2	6	2
493	2022-02-22 00:00:00	Whittakers Block Cocoa Dark 72% 250g	f	500	9	2	17	2
495	2022-02-22 00:00:00	NZ Trevally Fillets	f	0.346	7.61	1	7	2
496	2022-02-22 00:00:00	Avocado. Large Loose	f	4	4.40	7	24	2
500	2022-02-22 00:00:00	Mandarins Loose NZ	f	0.211	1.01	1	93	2
503	2022-02-22 00:00:00	Valumetric Colby Cheese 1kg	f	1.00	10.89	1	87	2
504	2022-02-08 01:03:00	Onions Brown Loose	f	0.952	2.85	1	1	1
506	2022-02-08 01:03:00	Macro Free Range Chicken Drumsticks	f	1.276	13.4	1	79	1
508	2022-02-08 01:03:00	Orange Navel Large Imported	f	0.332	1.99	1	117	1
509	2022-02-08 01:03:00	Fresh Ginger	f	0.112	1.79	1	47	1
512	2022-02-08 01:03:00	Macro Organic Tomatoes Diced NAS 400g	t	400	1.5	2	41	1
514	2022-02-08 01:03:00	Countdown Free Range Sz 7 12pk	f	744	6.9	2	6	1
515	2022-02-08 01:03:00	Woodland Free Range Eggs Sz6 18pk	f	954	8.8	2	6	1
516	2022-02-08 01:03:00	Lamb Mince Reduced	f	500	11.44	2	118	1
517	2022-02-08 01:03:00	Countdown Burger Patties Ultimate bbq beef steak 4pk	f	500.00	12	2	98	1
518	2022-02-08 01:03:00	Tasti Pinenuts 70g	f	70	5	2	119	1
519	2022-02-08 01:03:00	Avocado. Large Loose	f	2	2.8	7	24	1
520	2022-02-08 01:03:00	Cucumber Telegraph	f	1.00	2.99	7	46	1
524	2022-02-15 01:54:00	Watermelon Red Whole	f	2.815	7.04	1	86	1
525	2022-02-15 01:54:00	Chicken Thigh Boneless Skinless Large	f	1	18.68	1	120	1
526	2022-02-15 01:54:00	Woodlands Free Range Size 6 10 pk	f	530	4.90	2	6	1
527	2022-02-15 01:54:00	Countdown Free Range Sz 7 12pk	f	744	6.9	2	6	1
529	2022-02-15 01:54:00	Essentials Coconut Cream 400 mL	f	800	2.4	4	15	1
1429	2023-02-19 23:00:00	Oats, Jumbo Rolled split from Melody	t	5	20.5	1	164	6
531	2022-02-15 01:54:00	Macro Organic Tomatoes Diced NAS 400g	t	800.00	3	2	41	1
533	2022-02-15 01:54:00	Capsicum Odd Bunch 750g	f	750	5	2	25	1
534	2022-02-15 01:54:00	Avocado. Large Loose	f	2	2.8	7	24	1
535	2022-02-15 01:54:00	CD cheese mild 1 kg	f	1.00	11.8	1	109	1
536	2022-02-15 01:54:00	CD Premium Beef Stir Fry reduced	f	1	17.82	1	121	1
537	2022-01-25 23:00:00	Organic Medium Grain Brown Rice, Bulk	t	10	32.89	1	71	6
538	2022-02-04 23:00:00	Fill Your Own Honey	f	3.8	38	1	77	16
539	2022-02-08 23:00:00	Kelp Granules 250g	f	250	11.90	2	122	17
540	2022-02-08 23:01:00	Rye flour, share 25 kg bag	t	10	28.71	1	108	6
541	2022-02-08 23:01:00	Buckwheat Hulled, 25 kg share bag	t	13	60.72	1	123	6
542	2022-02-08 23:01:00	Wheat, whole, dressed 25 kg bag	t	25	80.42	1	124	6
543	2022-02-08 23:01:00	Coconut Flakes, 1.5 kg bag	t	1.5	13.19	1	125	6
227	2021-12-12 22:19:00	Onion Red 1.5 kg bag	f	1.5	4	1	1	1
317	2022-01-07 01:28:00	Onions Brown Loose	f	1.142	3.99	1	1	1
478	2022-01-31 23:07:00	Onions Brown Loose	f	0.851	2.12	1	1	2
544	2022-02-08 23:01:00	Sunflower Seeds, 3 kg bag	t	3	20.34	1	126	6
545	2022-02-08 23:01:00	Nutritional Yeast, 1 kg bag	t	1.00	48	1	64	6
546	2022-02-08 23:01:00	Sultanas, Bulk 2.5 kg bag	t	2.50	21.55	1	65	6
547	2022-02-08 23:01:00	Quinoa, White, 3.5 kg bag	t	3.5	34.75	1	63	6
548	2022-02-28 22:11:00	Fresh Ginger	f	0.192	3.07	1	47	1
551	2022-02-28 22:11:00	Macro Free Range Chicken Drumsticks	f	1.186	12.45	1	79	1
552	2022-02-28 22:11:00	WW Peach SLices in Fruit Juice 410g	f	1230.00	4.5	2	104	1
553	2022-02-28 22:11:00	Macro Organic Tomatoes Diced NAS 400g	t	400	1.5	2	41	1
554	2022-02-28 22:11:00	Countdown Free Range Sz 7 12pk	f	1488.00	13.80	2	6	1
555	2022-02-28 22:11:00	WW White Sugar 3 kg	f	3	5.60	1	23	1
556	2022-02-28 22:11:00	Ahg Fish Sauce 200mL	f	200	2.65	4	127	1
559	2022-02-28 22:11:00	CD Beef Mince 82% 1kg	f	1	14.5	1	18	1
560	2022-03-07 21:29:00	Essentials Coconut Cream 400 mL	f	1600.00	4.80	4	15	1
561	2022-03-07 21:29:00	Macro Organic Tomatoes Diced NAS 400g	t	1200.00	4.5	2	41	1
563	2022-03-07 21:29:00	Capsicum Odd Bunch 750g	f	750	5.5	2	25	1
564	2022-03-07 21:11:00	Otaika Valley Size 7 12 pack	f	2232.00	19.77	2	6	2
565	2022-03-07 21:11:00	Queens Diamond Pitted Dates 400g	f	400.00	2.1900	2	78	2
566	2022-03-07 21:11:00	Whittakers Block Cocoa Dark 72% 250g	f	500	9	2	17	2
567	2022-03-07 21:11:00	Avocado. Large Loose	f	4	4	7	24	2
575	2022-03-07 21:11:00	Raglan Coconut Yoghurt Vanilla 700mL	t	700.00	11	4	69	2
576	2022-03-07 21:11:00	Valumetric Edam Cheese 1 kg	f	1.00	10.89	1	109	2
577	2022-03-07 21:11:00	NZ Chicken Thigh Cutlets	f	0.464	5.1	1	120	2
580	2022-03-15 00:29:00	Watermelon Red Whole 1ea	f	2.56	6.4	1	86	1
581	2022-03-15 00:29:00	Fresh Ginger	f	0.242	3.87	1	47	1
582	2022-03-15 00:29:00	Countdown Free Range Sz 6 6pk Short Date Sale	f	2.60	16.17	1	6	1
583	2022-03-15 00:29:00	Doritos Corn Chips Original 170g	f	340.00	4	2	128	1
584	2022-03-15 00:29:00	Born & Bred NZ Prime Beef Mince 500g REDUCED	f	2	20.80	1	18	1
585	2022-03-15 00:29:00	Ocean Blue Smoked Salmon 180g	f	180	10	2	129	1
586	2022-03-15 00:29:00	CD cheese mild 1 kg	f	1.00	11.8	1	109	1
587	2022-03-15 00:29:00	Essentials Coconut Cream 400 mL	f	1200.00	3.6	4	15	1
588	2022-03-15 00:29:00	Macro Orgaic Passata 700g	t	2100	9	2	130	1
589	2022-03-15 00:29:00	Macro Organic Tomatoes Diced NAS 400g	t	400	1.50	2	41	1
590	2022-03-15 00:29:00	Whittakers Block Cocoa Dark 72% 250g	f	500	9	2	17	1
591	2022-03-15 00:29:00	Avocado. Large Loose	f	2	3.5	7	24	1
593	2022-03-15 00:29:00	WW White Sugar 3 kg	f	3.00	5.6	1	23	1
594	2022-03-15 01:37:00	Fresh Ginger	f	0.14	0.7	1	47	18
595	2022-03-15 01:37:00	Fresh Green Chillis	f	0.03	0.45	1	132	18
596	2022-03-22 21:45:00	Garlic NZ	f	0.032	1.22	1	49	1
597	2022-03-22 21:45:00	Macro Orgaic Passata 700g	t	700	3	2	130	1
599	2022-03-22 21:45:00	Raglan Coconut Yoghurt Blueberry 700g	t	700.00	12	2	69	1
600	2022-03-22 21:45:00	Whittakers Block Cocoa Dark 72% 250g	f	250	4.5	2	17	1
601	2022-03-22 21:45:00	Macro Org Wholewheat Penne 500g	t	500.00	2.8	2	114	1
602	2022-03-22 21:45:00	Mainland Cheese Vintage 500g	f	500	11	2	21	1
604	2022-03-22 22:08:00	OSM bars chocolate 6 pieces 507g NET 	f	12	25.78	7	67	2
605	2022-03-22 22:08:00	Otaika Valley Size 7 12 pack	f	2.23	19.77	1	6	2
606	2022-03-22 22:08:00	Whittakers Block Cocoa Dark 72% 250g	f	500	9	2	17	2
607	2022-03-22 22:08:00	Avocado. Large Loose	f	3	2	7	24	2
611	2022-03-28 21:55:00	Aurora Coffee Beans Prima Qualita 1kg	f	1	17.2	1	16	1
613	2022-03-28 21:49:00	Macro Free Range Chicken Thigh Fillet, Reduced	f	0.543	7.74	1	58	1
614	2022-03-28 21:49:00	Macro Free Range Chicken Thigh Fillet, Reduced	f	0.475	5.33	1	58	1
616	2022-03-28 21:49:00	Countdown Free Range Sz 7 12pk	f	744	6.9	2	6	1
617	2022-03-28 21:49:00	Macro Orgaic Passata 700g	t	1400	6	2	130	1
618	2022-03-28 21:49:00	Barkers SodaSyrup Brewed Ginger Beer 710mL	f	710	6.5	4	135	1
619	2022-03-28 21:49:00	Freshpak Rooibos Tea 40ea 100g	f	100	4.5	2	136	1
620	2022-03-28 21:49:00	Doritos Corn Chips Original 170g	f	170	2	2	128	1
625	2022-03-28 22:16:00	Capsicum Loose	f	1	2.49	7	25	18
627	2022-03-28 22:16:00	Conventional Cabbage	f	1.505	5.99	1	60	18
633	2022-04-05 02:37:00	Cucumber Telegraph	f	1.00	1.99	7	46	18
635	2022-04-05 02:37:00	Capsicum mixed bag	f	0.582	3.99	1	25	18
637	2022-04-05 02:37:00	Fiji Tumeric	f	0.085	1.02	1	139	18
638	2022-04-05 02:55:00	CD Beef Mince 1kg Reduced	f	2	17.88	1	18	1
640	2022-04-05 02:55:00	Broccoli Fresh	f	1.00	2	7	94	1
641	2022-04-05 02:55:00	Avocado. Large Loose	f	4	7	7	24	1
646	2022-04-12 22:37:00	Macro Free Range Chicken Thigh Fillet, Reduced	f	0.539	9.84	1	58	1
647	2022-04-12 22:37:00	Macro Free Range Chicken Thigh Fillet, Reduced	f	0.572	10.44	1	58	1
648	2022-04-12 22:37:00	Macro Free Range Chicken Thigh Fillet, Reduced	f	0.604	11.02	1	58	1
650	2022-04-12 22:37:00	Macro Orgaic Passata 700g	t	2100.00	9	2	130	1
651	2022-04-12 22:37:00	Whittakers Block Dark Ghana 250g	f	500	8	2	17	1
652	2022-04-12 22:37:00	Countdown Free Range Sz 7 12pk	f	1488.00	13.8	2	6	1
654	2022-04-12 22:37:00	Barkers SodaSyrup Brewed Ginger Beer 710mL	f	1420.00	10	4	135	1
656	2022-04-12 22:37:00	Fresh Red Chillis	f	2	3.4	7	132	1
657	2022-04-12 22:37:00	Avocado. Large Loose	f	2	3.5	7	24	1
659	2022-04-17 23:25:00	Garlic NZ	f	0.052	2.76	1	49	1
660	2022-04-20 00:19:00	Garam Masala Bulk Bin	f	0.052	2.18	1	140	4
661	2022-04-20 00:19:00	Ground Ginger Bulk Bin	f	0.06	2.69	1	141	4
153	2021-11-23 00:42:00	Macro Organic White Washed Potatoes 1.5 kg	t	1.5	8.5	1	2	1
363	2021-10-28 02:33:00	Onions Brown Loose	f	0.487	1.22	1	1	1
439	2022-01-24 21:21:00	Onions Brown Loose	f	0.152	0.53	1	1	1
645	2022-04-12 22:37:00	Onions Brown Loose	f	0.382	1.14	1	1	1
662	2022-04-20 00:19:00	Brewer's Yeast, from Bulk Bin	f	126	4.4	2	61	4
663	2022-04-20 00:19:00	Paprika Bulk Bin	f	0.086	2.8	1	142	4
668	2022-04-20 01:03:00	Chicken Thigh Boneless Skinless Large	f	1.038	18.04	1	120	1
1407	2023-02-04 23:00:00	Tulsi Tumeric Ginger Tea 18 bags	t	34.2	10.98	2	20	29
1408	2023-02-04 23:00:00	Organic India Tulsi Ashwagandha 18bags	t	36	11.27	2	20	29
669	2022-04-20 01:03:00	Macro Orgaic Passata 700g	t	2800.00	12	2	130	1
670	2022-04-20 01:03:00	WW Tomatoes Diced Italian 800g	f	1.6	4	1	41	1
671	2022-04-20 01:03:00	Macro Organic Tomatoes Diced NAS 400g	t	800	3.6	2	41	1
673	2022-04-20 01:03:00	Cabbage Red Whole	f	1	6.99	7	60	1
674	2022-04-23 21:47:00	Pam's Baking Soda 500g	f	500	2.47	2	143	2
676	2022-04-23 21:47:00	Cucumber Telegraph	f	2	5	7	46	2
677	2022-04-20 02:34:00	Otaika Valley Size 7 12 pack	f	1488.00	13.18	2	6	2
678	2022-04-20 02:34:00	Whittakers Block Peanut Butter Jelly 250g	f	250	2.99	2	17	2
681	2022-04-20 02:34:00	Avocado. Large Loose	f	2	3	7	24	2
684	2022-04-11 00:00:00	No Label Jumbo dozen eggs	f	800.00	5.50	2	6	11
685	2022-05-10 22:53:00	Macro Free Range Chicken Whole	f	1.65	15.84	1	133	1
686	2022-05-10 22:53:00	CD Chicken Nibbles Med Reduced	f	1.108	7.52	1	134	1
688	2022-05-10 22:53:00	Countdown Free Range Sz 7 12pk	f	1488.00	13.8	2	6	1
689	2022-05-10 22:53:00	Waitoa FR Chicken Thigh Fillet 400g	f	0.8	18.72	1	58	1
690	2022-05-10 22:53:00	CD Beef Mince 1kg Reduced	f	1	11.47	1	18	1
692	2022-05-10 22:53:00	Doritos Corn Chips Original 170g	f	340.00	3.8	2	128	1
693	2022-05-10 22:53:00	WW Dates Pitted 500g	f	500	2.40	2	78	1
695	2022-05-10 22:22:00	Karajoz Organic Coffee Beans	f	0.75	20.49	1	16	2
696	2022-05-10 22:22:00	Pams Flour Plain 1.5 kg	f	1.50	1.8	1	70	2
698	2022-05-10 22:22:00	Whittakers Block Cocoa Dark 72% 250g	f	1000	16	2	17	2
699	2022-05-10 22:22:00	NZ Red Cod Fillets	f	0.544	10.77	1	7	2
701	2022-05-10 22:22:00	Avocado. Large Loose	f	2	4	7	24	2
704	2022-05-10 22:22:00	Beetroot Conventional	f	0.226	1.11	1	32	2
705	2022-05-10 22:22:00	Cabbage Green Whole	f	1	4.99	7	60	2
711	2022-05-18 02:05:00	Fresh Ginger	f	0.232	3.83	1	47	1
715	2022-05-18 02:05:00	Macro Organic Tomatoes Diced NAS 400g	t	800	3.6	2	41	1
716	2022-05-18 02:05:00	Macro Orgaic Passata 700g	t	1400.00	6	2	130	1
717	2022-05-18 02:05:00	CD Free Range Eggs Sz8 6pack reduced	f	810.00	6.2	2	6	1
718	2022-05-18 02:05:00	Countdown Free Range Sz 6 6pk Short Date Sale	f	636.00	5.20	2	6	1
720	2022-05-18 02:05:00	Countdown Free Range Sz 7 12pk	f	744	6.9	2	6	1
721	2022-05-18 02:05:00	Tostitos Splash of Lime 175g	f	175	2.5	2	56	1
724	2022-05-24 21:00:00	Garlic NZ	f	0.05	2.65	1	49	1
726	2022-05-24 21:00:00	CD Chicken Frames by Weight	f	1.6	6.4	1	103	1
727	2022-05-24 21:00:00	Essentials Coconut Cream 400 mL	f	1200.00	4.2	4	15	1
728	2022-05-24 21:00:00	Macro Organic Tomatoes Diced NAS 400g	t	400	1.8	2	41	1
729	2022-05-24 21:00:00	Doritos Corn Chips Original 170g	f	510.00	6	2	128	1
731	2022-05-24 21:00:00	Macro Orgaic Passata 700g	t	2800.00	12	2	130	1
733	2022-05-27 00:00:00	Alberts Size J 20 pack	f	1455	7.5	2	6	11
734	2022-05-16 12:00:00	No Label Jumbo dozen eggs	f	800.00	5.5	2	6	11
735	2022-05-19 00:00:00	Buckwheat Hulled, 25 kg share bag	t	25	118.27	1	123	6
736	2022-04-11 00:00:00	Almonds, Transitional, 2.5 kg bag	f	2.50	56.6600	1	62	6
737	2022-04-11 00:00:00	Bulk Mung Beans Ceres 3.5 kg bag	t	3.5	27.01	1	73	6
738	2022-04-11 00:00:00	Wheat, whole, dressed 25 kg bag	t	25.00	80.13	1	124	6
739	2022-04-11 00:00:00	Ceres Bulk Cacao Powder 2.2kg	t	2.2	41.80	1	144	6
740	2022-04-11 00:00:00	Ceres Bulk Coconut Oil Organic 4.5L	t	4.5	38.4	3	111	6
741	2022-04-11 00:00:00	Licorice and Cinnamon Tea, Pukka 20 count box 40g NET	t	40.00	15.5000	5	76	6
743	2022-05-31 22:56:00	Fresh Ginger	f	0.162	2.67	1	47	1
744	2022-05-31 22:56:00	CD Beef Scotch Fillet Steak REDUCED	f	0.675	15.49	1	145	1
745	2022-05-31 22:56:00	CD Chicken Nibbles Med Reduced	f	0.637	4.18	1	134	1
748	2022-05-31 22:56:00	CD Still Spring Water 1.5L	f	1.5	0.9	3	55	1
749	2022-05-31 22:56:00	WW Peach SLices in Fruit Juice 410g	f	1640.00	6	2	104	1
750	2022-05-31 22:56:00	Essentials Coconut Cream 400 mL	f	1200	4.2	4	15	1
751	2022-05-31 22:56:00	Macro Orgaic Passata 700g	t	700	3.00	2	130	1
752	2022-05-31 22:56:00	Odd Bunch Avocados 1kg	f	1	7	1	24	1
753	2022-05-31 22:56:00	Sun Valley Brown Lentils 500g	f	0.5	2.89	1	146	1
754	2022-05-31 22:56:00	McKenzies Peas Split Green 500g	f	0.5	1.99	1	147	1
755	2022-05-31 22:56:00	Cerebos Coarse Salt 500g	f	0.5	2.19	1	75	1
756	2022-05-31 22:56:00	Rocket Prime NZ Beef Meatballs 490g REDUCED	f	0.98	12.88	1	148	1
757	2022-05-31 22:56:00	CD Beef Mince 1kg Reduced	f	1	11.47	1	18	1
758	2022-05-31 22:56:00	Raglan Coconut Yoghurt Vanilla 700g	f	700.00	12.99	2	69	1
759	2022-05-31 22:56:00	Mainland Cheese Vintage 500g	f	500	12.20	2	21	1
760	2022-05-31 22:56:00	Mexicano Corn Chips Natural 300g	f	300	3	2	56	1
761	2022-05-31 22:56:00	WW Crinkle Cut Chips Salted 150g	f	150	1.5	2	149	1
762	2022-06-22 00:00:00	NZ Snapper Heads	f	1.802	8.24	1	30	9
763	2022-06-22 01:00:00	1 kg Avocados Spray Free	f	1	5	1	24	7
768	2022-06-21 23:33:00	San Remo Pasta No5 Spaghetti 500g	f	500.00	2	2	114	1
769	2022-06-21 23:33:00	WW Tuna in Springwater 185g	f	1480.00	16	2	57	1
770	2022-06-21 23:33:00	Essentials Coconut Cream 400 mL	f	1200	4.2	4	15	1
771	2022-06-21 23:33:00	Doritos Corn Chips Original 170g	f	340.00	4	2	128	1
130	2021-11-15 19:44:00	Macro Organic White Washed Potatoes 1.5kg Reduced Price	t	1.5	5.95	1	2	1
233	2021-12-12 22:19:00	Organic Potato	t	2	6.99	1	2	1
284	2021-11-03 23:13:00	Macro Organic White Washed Potatoes 1.5 kg	t	1.5	8.5	1	2	1
391	2021-12-31 03:00:00	Organic Potato	t	4	13.98	1	2	1
505	2022-02-08 01:03:00	Potatoes Agria Brushed Loose	f	1.492	5.95	1	2	1
772	2022-06-21 23:33:00	WW Crinkle Cut Chips Ready 150g	f	150	1.5	2	149	1
773	2022-06-21 23:33:00	Orchard Gold Peaches & Blueberry 1kg	f	1.00	10.5	1	150	1
774	2022-06-21 23:33:00	McCain Peas Frozen 1kg	f	1.00	3.5	1	34	1
775	2022-06-21 23:33:00	Rocket Prime NZ Beef Patties 600g REDUCED	f	600	7.15	2	151	1
776	2022-06-21 23:33:00	WW Maple Syrup 250mL	f	250	7.5	4	152	1
778	2022-06-21 23:33:00	Countdown Free Range Sz 7 12pk	f	744	6.9	2	6	1
779	2022-06-16 00:54:00	ETA Ripples Ready Salted 150g	f	300	2	2	149	2
780	2022-06-16 00:54:00	Heyden Farms Free Range Sz8 10pk	f	675	6.59	2	6	2
783	2022-06-16 00:54:00	Pears Taylors Gold Reduced	f	4	2.95	7	97	2
785	2022-06-16 00:54:00	Gopala Natural Yoghurt Full Cream 750g	f	750	3.05	2	153	2
790	2022-06-09 23:27:00	WW Tuna in Springwater 185g	f	1665.00	18	2	57	1
791	2022-06-09 23:27:00	Naked Locals Soup Potato & Leek 500g	f	500	5	2	154	1
793	2022-06-09 23:27:00	Macro Organic Whole Egg Mayo 440g	t	440.00	6.5000	2	105	1
794	2022-06-09 23:27:00	Countdown Free Range Sz 7 12pk	f	744	6.90	2	6	1
795	2022-06-09 01:39:00	Ceres Organic Black Beans 400g	t	800	3.33	2	110	2
796	2022-06-09 01:39:00	Ceres Organic0 Chickpeas 400g	t	800	3.33	2	110	2
797	2022-06-09 01:39:00	Ceres Organic Kidney Beans 400g	t	800	3.34	2	110	2
798	2022-06-09 01:39:00	ETA Ripples Ready Salted 150g	f	450	2.97	2	149	2
799	2022-06-09 01:39:00	Karajoz Organic Coffee Beans 750g	t	750	17	2	16	2
800	2022-06-09 01:39:00	Mrs Rogers Premium Sea Salt Fine 1kg	f	2	4.18	1	75	2
801	2022-06-09 01:39:00	Pams Four Bean Mix in Brine 400g	f	800	1.6	2	110	2
806	2022-06-22 22:05:00	Beef Topside Roast Reduced	f	1.228	15.95	1	155	1
807	2022-06-22 22:05:00	WW Crinkle Cut Chips Ready 150g	f	150	1.5	2	149	1
808	2022-06-22 22:05:00	WW Brazil Nuts 150g	f	150	6.5	2	88	1
809	2022-06-22 22:05:00	CD Premium Beef Mince 500g Reduced	f	0.5	10.79	1	18	1
810	2022-07-07 23:06:00	Ceres Organics Soy Sauce Tamari 250mL	t	250	6.59	4	156	2
811	2022-07-07 23:06:00	ETA Ripples Ready Salted 150g	f	750	4.95	2	149	2
812	2022-07-07 23:06:00	Oreo Cookie Chocolate 133g	f	133	1.59	2	157	2
813	2022-07-07 23:06:00	Oreo Mini Multipack 230g	f	460.00	5.00	2	157	2
814	2022-07-07 23:06:00	T/Colledge Vanilla Exract 100 mL FairTrade	f	100	9.59	4	28	2
815	2022-07-07 23:06:00	Whittakers Block Cocoa Dark 72% 250g	f	500	9	2	17	2
817	2022-07-07 23:06:00	Fresh Ginger	f	0.261	2.61	1	47	2
818	2022-07-07 23:06:00	Kiwifruit Green NZ	f	0.091	0.27	1	96	2
821	2022-07-07 23:06:00	Killinchy Gold Vanilla 1L	f	1	9.49	3	33	2
822	2022-07-07 23:06:00	The Berry Fix Frozen Blueberries 1.8kg	f	1.8	15.99	1	101	2
823	2022-07-07 23:06:00	Lisas Hummus Gloriously Garlic 380g	f	380	5.59	2	158	2
824	2022-07-07 23:06:00	Valumetric Colby Cheese 1kg	f	1.00	9.79	1	87	2
826	2022-07-11 23:13:00	Pams Cornflour Maize 400g	f	0.4	1.39	1	159	2
827	2022-07-11 23:13:00	Whittakers Block Cocoa Dark 72% 250g	f	250	4.5	2	17	2
828	2022-07-11 23:13:00	Hoki Fillets Fresh	f	0.598	10.16	1	7	2
830	2022-07-11 23:13:00	Avocado. Large Loose	f	4	5	7	24	2
832	2022-07-11 23:13:00	BAPS plain 6pk	f	6	2.69	7	160	2
833	2022-06-03 00:00:00	Alberts Size J 20 pack	f	1455.00	7.5000	2	6	11
834	2022-07-12 00:00:00	King Bell Peppers, large SF	f	3	5	7	25	7
835	2022-06-20 00:00:00	Alberts Size J 20 pack	f	1455.00	7.5000	2	6	11
836	2022-07-01 00:00:00	Alberts Size J 20 pack	f	1455.00	7.5000	2	6	11
838	2022-07-08 00:00:00	Macro Orgaic Passata 700g	t	3500.00	17.5	2	130	1
839	2022-07-08 00:00:00	Essentials Coconut Cream 400 mL	f	1600.00	5.6	4	15	1
840	2022-07-08 00:00:00	Giannis Crispy Pizza Bases	f	4	4.3	7	161	1
841	2022-07-08 00:00:00	Clearly Premium Duo Nat & Gravlax 150g	f	150	8	2	129	1
842	2022-07-08 00:00:00	Chicken Mince 450g REDUCED	f	1.35	14.52	1	81	1
843	2022-07-08 00:00:00	WW Black Sliced Olives 430g	f	430.00	3.2000	2	113	1
844	2022-07-08 00:00:00	Doritos Corn Chips Original 170g	f	510.00	5.49	2	128	1
845	2022-07-08 00:00:00	Mexicano Corn Chips Natural 300g	f	300	3	2	56	1
846	2022-07-08 00:00:00	Macro Organic Tomatoes Diced NAS 400g	t	800	3.60	2	41	1
848	2022-07-08 00:00:00	Verkerks Wagyu Salami 100g	f	100	9.49	2	162	1
849	2022-07-08 00:00:00	Alpine Grated Mozzarella Cheese 550g	f	0.55	9.9	1	163	1
850	2022-07-18 23:20:00	Onions Brown Loose	f	0.152	0.38	1	1	1
851	2022-07-18 23:20:00	Organic Agria Potatoes 5kg	t	5	13	1	2	1
852	2022-07-18 23:20:00	Essentials Coconut Cream 400 mL	f	1200	4.2	4	15	1
853	2022-07-18 23:20:00	WW Dates Pitted 500g	f	500	2.4	2	78	1
856	2022-04-11 00:01:00	Oats, Jumbo Rolled	t	1.3	6.45	1	164	6
857	2022-06-08 00:00:00	Ground Cinnamon, Ceres split 1kg bag	t	0.5	10.12	1	165	6
858	2022-06-08 00:00:00	Demerara Sugar, Ceres 4kg	t	4	17.56	1	166	6
859	2022-06-08 00:00:00	Coconut Sugar, Ceres 3kg	t	3	24.26	1	167	6
861	2022-06-08 00:00:00	Bulk Red Lentils Ceres 3.5 kg bag	t	3.50	25.49	1	72	6
863	2022-06-08 00:00:00	Hemp Hearts split 3 kg bag	t	1.5	33.2	1	66	6
866	2022-07-18 21:56:00	Pure South Halal Beef Mince Prime 1kg	f	3	39.68	1	18	19
867	2022-07-19 00:06:00	Oreo Cookie Chocolate 133g	f	266.00	1.98	2	157	2
3	2021-06-17 04:41:00	Arnotts vita-weat cracked pepper	f	250	3.5	2	3	1
19	2021-06-22 23:31:00	Arnotts Vita-weat Cracked Pepper 250g	f	1	10	1	3	1
120	2021-07-14 22:30:00	Arnotts Vita-weat Cracked Pepper 250g	f	500.00	5	2	3	1
168	2021-11-29 20:45:00	Huntley & Palmers Rosemary Garlic Crackers	f	200	3.40	2	3	1
228	2021-12-12 22:19:00	Arnotts Vita-weat Cracked Pepper 250g	f	250	3	2	3	1
350	2021-10-22 00:02:00	Arnotts Vita-weat Cracked Pepper 250g	f	250	3	2	3	1
368	2021-10-28 02:33:00	Organic Potato	t	2	6.99	1	2	1
395	2021-12-31 03:00:00	Arnotts Vita-weat Cracked Pepper 250g	f	250	3	2	3	1
447	2022-01-31 23:40:00	Arnotts Vita-weat Cracked Pepper 250g	f	500	6	2	3	1
513	2022-02-08 01:03:00	Arnotts Vita-weat Cracked Pepper 250g	f	250	3	2	3	1
521	2022-02-15 01:54:00	Onions Brown Loose	f	0.577	1.73	1	1	1
530	2022-02-15 01:54:00	Organic Potato	t	2	8	1	2	1
615	2022-03-28 21:49:00	Arnotts Vita-weat Cracked Pepper 250g	f	750	9	2	3	1
653	2022-04-12 22:37:00	Arnotts Vita-weat Cracked Pepper 250g	f	250	3.5	2	3	1
868	2022-07-19 00:06:00	Whittakers Block Cocoa Dark 72% 250g	f	250	4.5	2	17	2
869	2022-07-19 00:06:00	Avocado Loose	f	1	1.69	7	24	2
873	2022-07-01 00:00:00	CD cheese mild 1 kg	f	1.00	13.5	1	109	1
874	2022-07-01 00:00:00	Mainland Cheese Organic 500g	t	0.5	12.2	1	42	1
876	2022-07-01 00:00:00	Garlic NZ	f	0.1	5.3	1	49	1
879	2022-07-01 00:00:00	CD Beef Mince 82% 1kg	f	1	14.90	1	18	1
882	2022-07-01 00:00:00	WW Tuna in Springwater 185g	f	370.00	4	2	57	1
883	2022-07-01 00:00:00	WW Crinkle Cut Chips Sour cream 150g	f	150	1.5	2	149	1
884	2022-07-01 00:00:00	Whittakers Block Cocoa Dark 72% 250g	f	250	5.50	2	17	1
885	2022-07-01 00:00:00	Mexicano Corn Chips Natural 300g	f	300	3.8	2	56	1
886	2022-07-15 04:36:00	Fill Your Own Honey	f	4.3	40	1	77	16
890	2022-08-04 22:14:00	Small Bell Peppers	f	5	5	7	25	7
891	2022-08-04 22:14:00	Avocado Small	f	0.547	5	1	24	7
892	2022-08-04 22:14:00	Local Spray Free Parsnips	f	0.48	3	1	40	7
894	2022-08-04 22:14:00	Fowler's Free Range Eggs Sz 7 12pk	f	0.744	9	1	6	7
896	2022-08-09 22:45:00	Fresh Ginger	f	0.157	2.59	1	47	1
900	2022-08-09 22:45:00	Essentials Coconut Cream 400 mL	f	800	2.8	4	15	1
901	2022-08-09 22:45:00	WW Black Sliced Olives 430g	f	430.00	3.2000	2	113	1
902	2022-08-09 22:45:00	Mainland Cheese Vintage 500g	f	0.5	13	1	21	1
904	2022-08-09 22:45:00	Freshpak Rooibos Tea 40ea 100g	f	100	5	2	136	1
905	2022-08-09 22:45:00	CD Premium Beef Mince 88% 1kg Reduced	f	1	14.43	1	18	1
907	2022-07-25 03:40:00	CD Chicken Cutlets Small	f	0.55	6.24	1	54	1
909	2022-07-25 03:40:00	Cabbage Red Whole Big	f	1	7	7	60	1
910	2022-07-25 03:40:00	WW Tuna in Springwater 185g	f	740.00	8	2	57	1
912	2022-07-25 03:40:00	Essentials Coconut Cream 400 mL	f	400	1.4	4	15	1
913	2022-07-25 03:40:00	WW Tomatoes Diced Italian 800g	f	1.60	4	1	41	1
914	2022-08-11 22:17:00	Karajoz Organic Coffee Beans 750g	t	0.75	18	1	16	2
915	2022-08-11 22:17:00	Mrs Rogers Premium Sea Salt Fine 1kg	f	2	4.98	1	75	2
916	2022-08-11 22:17:00	Oreo Cookie Chocolate 133g	f	133	0.99	2	157	2
917	2022-08-11 22:17:00	Pam's Dark Chocolate Chips 400g	f	0.4	2.99	1	19	2
918	2022-08-11 22:17:00	Pam's Dark Chocolate Drops 400g	f	0.4	2.99	1	19	2
919	2022-08-11 22:17:00	T/Colledge Vanilla Exract 100 mL FairTrade	f	100	9.59	4	28	2
920	2022-08-11 22:17:00	Value Tomatoes Chopped in Juice 400g	f	1.60	2.76	1	41	2
921	2022-08-11 22:17:00	Whittakers Block Cocoa Dark 72% 250g	f	250	4.5	2	17	2
922	2022-08-11 22:17:00	NZ Snapper Heads	f	0.924	6.46	1	30	2
923	2022-08-11 22:17:00	Beetroot Conventional	f	0.311	1.52	1	32	2
928	2022-08-11 22:17:00	The Berry Fix Frozen Blueberries 1.8kg	f	1.8	15.99	1	101	2
929	2022-08-11 22:17:00	Raglan Coconut Yoghurt Vanilla 700mL	f	700.00	8.99	4	69	2
930	2022-08-04 23:12:00	Fresh Ginger	f	0.232	3.83	1	47	1
933	2022-08-04 23:12:00	Cabbage Green Whole	f	1	4.5	7	60	1
934	2022-08-04 23:12:00	WW Dates Pitted 500g	f	500	2.4	2	78	1
935	2022-08-04 23:12:00	WW Tomatoes Diced Italian 800g	f	0.8	2	1	41	1
936	2022-08-04 23:12:00	Essentials Coconut Cream 400 mL	f	400	1.4	4	15	1
937	2022-08-04 23:12:00	Mainland Cheese Vintage 250g	f	0.25	7.5	1	21	1
938	2022-08-04 23:12:00	Doritos Corn Chips Original 170g	f	340.00	3.8	2	128	1
939	2022-08-04 23:12:00	Pukka Tea Three Ginger 20ea	t	20	8	5	76	1
941	2022-07-08 00:00:00	Albert's Eggs Size J 20pk	f	1.455	7.5	1	173	11
942	2022-07-17 00:00:00	Albert's Eggs Size J 20pk	f	1455	7.5000	2	173	11
943	2022-07-18 00:00:00	Albert's Eggs Size J 20pk	f	1455	7.5000	2	173	11
944	2022-08-02 00:00:00	Albert's Eggs Size J 20pk	f	1455	7.5000	2	173	11
946	2022-08-12 00:00:00	Albert's Eggs Size J 20pk	f	1455	7.9	2	173	11
1430	2023-03-25 23:00:00	Albert's Eggs 12 Pack weighed	f	0.87	8.5000	1	173	11
528	2022-02-15 01:54:00	Arnotts Vita-weat Cracked Pepper 250g	f	500	6	2	3	1
562	2022-03-07 21:29:00	Macro Org Brushed Potato 1 kg	t	1	4.5	1	2	1
573	2022-03-07 21:11:00	Onions Brown Loose	f	0.971	1.93	1	1	2
579	2022-03-15 00:29:00	Onions Brown Loose	f	0.177	0.53	1	1	1
603	2022-03-22 21:45:00	Arnotts Vita-weat Crackers Regular 250g	f	250	3	2	3	1
667	2022-04-20 01:03:00	Onions Brown Loose	f	0.297	0.89	1	1	1
708	2022-05-10 22:22:00	Onions Brown Loose	f	0.301	0.6	1	1	2
713	2022-05-18 02:05:00	Arnotts Vita-weat Cracked Pepper 250g	f	1000	10	2	3	1
947	2022-08-07 00:00:00	Sultanas, Bulk 2.5 kg bag	t	2.5	23.25	1	65	6
948	2022-08-07 00:00:00	Chocolate Chips, SHARE 10 kg bag	t	1	27.91	1	19	6
949	2022-08-07 00:00:00	Coconut Sugar, Ceres 3kg	t	3.00	24.2600	1	167	6
950	2022-08-07 00:00:00	Rye flour, share 25 kg bag	t	15	61.11	1	108	6
951	2022-08-07 00:00:00	Nutritional Yeast, 1 kg bag	t	1.00	48.64	1	64	6
953	2022-09-15 22:30:00	Avocado. Large Loose	f	1	1.9	7	24	1
955	2022-09-15 22:30:00	Garlic NZ	f	0.05	2	1	49	1
960	2022-09-15 22:30:00	Essentials Baking Soda 500g	f	500.00	2.3	2	143	1
961	2022-09-15 22:30:00	Essentials Coconut Cream 400 mL	f	400	1.5	4	15	1
962	2022-09-15 22:30:00	Doritos Corn Chips Original 170g	f	170	2	2	128	1
963	2022-09-15 22:30:00	Whittakers Block Cocoa Dark 72% 250g	f	750.00	12.6	2	17	1
964	2022-09-15 22:30:00	WW Olives Green Whole 450g	f	450	3	2	113	1
965	2022-09-15 22:30:00	Exotic Food Red Curry Paste 220g	f	220	4.5	2	45	1
967	2022-09-01 22:36:00	Kumara Romanua	t	0.26	2.6	1	10	21
968	2022-09-01 22:36:00	Kumara Beauregard	t	0.38	3.8	1	10	21
969	2022-09-01 22:36:00	Chickpeas Bulk Bin Organic	t	0.755	7.54	1	176	21
970	2022-09-01 23:18:00	Mrs Rogers Himalayan Fine Salt 1kg	f	1	4.39	1	75	2
971	2022-09-01 23:18:00	T/Colledge Vanilla Exract 100 mL FairTrade	f	100	9.59	4	28	2
972	2022-09-01 23:18:00	Apples Royal Gala	f	1.236	4.93	1	9	2
973	2022-09-01 23:18:00	Avocado. Large Loose	f	1	1.49	7	24	2
974	2022-09-01 23:18:00	Bananas Conventional	f	0.676	1.95	1	4	2
975	2022-09-01 23:18:00	Beetroot Conventional	f	0.326	1.59	1	32	2
976	2022-09-01 23:18:00	Cabbage Red Whole	f	1	7.99	7	60	2
978	2022-09-01 23:18:00	Kiwifruit Green NZ	f	0.801	1.59	1	96	2
980	2022-09-01 23:18:00	Onions Brown Loose	f	0.766	1.37	1	1	2
982	2022-09-01 23:18:00	Whittakers Block Cocoa Dark 72% 250g	f	750	13.5	2	17	2
985	2022-08-31 23:36:00	Apples Braeburn	f	0.212	0.74	1	9	1
986	2022-08-31 23:36:00	Macro Free Range Chicken Thigh Cutlet	f	0.523	10.46	1	58	1
987	2022-08-31 23:36:00	Macro Orgaic Passata 700g	t	700	3.5	2	130	1
989	2022-08-31 23:36:00	Essentials Coconut Cream 400 mL	f	1600	5.6	4	15	1
991	2022-08-31 23:36:00	Arnotts Vita-weat Cracked Pepper 250g	f	250	3.3	2	3	1
992	2022-08-31 23:36:00	CD Beef Mince 500g Reduced	f	1.5	15.6	1	18	1
993	2022-08-31 23:36:00	Lisas Hummus Plain 380g	f	380.00	5.9	2	158	1
994	2022-08-31 23:36:00	CD Premium Beef Stir Fry reduced	f	0.5	9.23	1	121	1
995	2022-08-31 23:36:00	Macro Free Range Chicken Mince Reduced	f	450.00	6.4	2	80	1
996	2022-08-31 23:36:00	Doritos Corn Chips Original 170g	f	340.00	4	2	128	1
997	2022-09-22 23:35:00	OSM bars chocolate 6 pieces 507g NET 	f	6	14.6	7	67	1
998	2022-09-24 23:03:00	Mandarins Afourer	f	0.447	2.15	1	93	1
999	2022-09-24 23:03:00	Essentials Coconut Cream 400 mL	f	2000.00	7.5	4	15	1
1000	2022-09-24 23:03:00	WW Black Sliced Olives 430g	f	430	3.2	2	113	1
1001	2022-09-24 23:03:00	WW White Sugar 1.5kg	f	1.5	1.5	1	23	1
1002	2022-09-24 23:03:00	WW Thin Rice Cracker Salt&Ving 100g	f	100	1.2	2	3	1
1005	2022-09-22 21:12:00	Ceres Org Passata Basil 680g	t	1360.00	5	2	130	2
1006	2022-09-22 21:12:00	Value Tomatoes Whole 400g	f	4.80	8.28	1	41	2
1008	2022-09-22 21:12:00	Avocado. Large Loose	f	3	2	7	24	2
1010	2022-09-22 21:12:00	Cabbage Green Medium	f	1	4.99	7	60	2
1012	2022-09-22 21:12:00	Mandarins Loose NZ	f	0.166	0.83	1	93	2
1013	2022-09-22 21:12:00	Mandarins Loose NZ	f	0.076	0.38	1	93	2
1017	2022-08-26 00:00:00	CD Chicken Frames by Weight	f	1.495	6.72	1	103	1
1018	2022-08-26 00:00:00	Essentials Coconut Cream 400 mL	f	400	1.4	4	15	1
1019	2022-08-26 00:00:00	WW Dates Pitted 500g	f	500	2.4	2	78	1
1021	2022-08-26 00:00:00	WW Tomatoes Diced Italian 400g	f	400	1.200	2	41	1
1022	2022-08-26 00:00:00	Macro Organic Tomatoes Diced NAS 400g	t	400	1.8	2	41	1
1023	2022-08-26 00:00:00	Whittakers Block Cocoa Dark 72% 250g	f	250	5	2	17	1
1024	2022-08-26 00:00:00	OSM bars chocolate 6 pieces 480g NET 	f	6	14.6	7	67	1
1025	2022-08-26 00:00:00	Freshpak Rooibos Tea 40ea 100g	f	100.00	5	2	136	1
1028	2022-09-03 00:00:00	Organic Beef Mince Lean 400g	t	0.4	12	1	18	8
1029	2022-10-23 04:34:00	Mandarins Afourer	f	0.712	3.56	1	93	1
1030	2022-10-23 04:34:00	Orange Navel Loose	f	0.937	4.5	1	117	1
1034	2022-10-21 06:04:00	Fresh Ginger	f	0.292	3.79	1	47	1
1035	2022-10-21 06:04:00	Mandarins Afourer	f	1.2232	6.16	1	93	1
1040	2022-10-27 00:20:00	Mandarins Afourer	f	1.097	5.49	1	93	1
1041	2022-10-27 00:20:00	Kumara Orange	f	0.902	1.8	1	10	1
1042	2022-10-27 00:20:00	Countdown Free Range Sz 6 6pk Short Date Sale	f	954.00	7.86	2	6	1
1043	2022-10-27 00:20:00	Tararua Salted Butter 500g	f	0.5	5	1	12	1
4	2021-06-17 04:41:00	Short date bananas on special	f	2	3	6	4	1
58	2021-08-05 05:33:00	Bananas Conventional	f	1.131	3.04	1	4	2
88	2021-08-12 01:33:00	Quick Sale Bananas Freetrade 	f	2	3	1	4	1
99	2021-08-19 01:08:00	Bananas Cavendish	f	0.922	2.58	1	4	1
135	2021-11-15 19:44:00	Banana Fairtrade Organic 850g	t	850	4.5	2	4	1
146	2021-11-23 00:42:00	Bananas Cavendish	f	1.207	3.62	1	4	1
161	2021-11-29 20:45:00	Bananas Cavendish	f	0.742	2.23	1	4	1
206	2021-12-04 23:11:00	Bananas Conventional	f	0.671	1.54	1	4	2
219	2021-12-12 22:19:00	Bananas Cavendish	f	1.182	3.55	1	4	1
259	2021-12-20 23:18:00	Bananas Conventional	f	1.826	4.91	1	4	2
290	2021-11-09 01:09:00	Bananas Cavendish	f	0.902	2.71	1	4	1
297	2021-11-11 01:02:00	Bananas Conventional	f	1.92	3.83	1	4	2
307	2021-12-27 03:50:00	Bananas Cavendish	f	1.121	2.57	1	4	2
332	2022-01-11 02:54:00	Bananas Conventional	f	0.831	2.24	1	4	2
349	2021-10-22 00:02:00	Bananas Cavendish	f	1.232	3.45	1	4	1
376	2021-10-31 01:06:00	Bananas Conventional	f	1.226	2.44	1	4	2
381	2021-12-31 03:00:00	Bananas Conventional	f	2	5.60	1	4	1
407	2022-01-17 20:17:00	Bananas Cavendish	f	1.137	3.41	1	4	1
435	2022-01-24 21:21:00	Bananas Cavendish	f	0.717	2.15	1	4	1
472	2022-01-31 23:07:00	Bananas Conventional	f	1.391	2.77	1	4	2
507	2022-02-08 01:03:00	Bananas Cavendish	f	1.212	4	1	4	1
522	2022-02-15 01:54:00	Bananas Cavendish	f	0.912	3.01	1	4	1
550	2022-02-28 22:11:00	Bananas Cavendish	f	1.777	5.86	1	4	1
568	2022-03-07 21:11:00	Bananas Conventional	f	0.876	2.53	1	4	2
569	2022-03-07 21:11:00	Bananas Conventional	f	0.206	0.6	1	4	2
643	2022-04-12 22:37:00	Bananas Cavendish	f	0.312	1.03	1	4	1
675	2022-04-23 21:47:00	Bananas Conventional	f	0.826	2.39	1	4	2
687	2022-05-10 22:53:00	Arnotts Vita-weat Cracked Pepper 250g	f	250	3.5	2	3	1
712	2022-05-18 02:05:00	Bananas Cavendish	f	0.932	3.08	1	4	1
765	2022-06-21 23:33:00	Onions Brown Loose	f	0.392	1.17	1	1	1
767	2022-06-21 23:33:00	Organic Agria Potatoes 5kg	t	5	13	1	2	1
789	2022-06-09 23:27:00	Organic Potato 2kg Reduced	t	2	5.2	1	2	1
804	2022-06-09 01:39:00	Onions Brown Loose	f	0.131	0.26	1	1	2
805	2022-06-09 01:39:00	Potatoes Agria Brushed Loose	f	0.431	1.07	1	2	2
1045	2022-10-27 00:20:00	Duck Island Coconut Carmel Vegan 472mL	f	472	5	4	33	1
1047	2022-10-27 00:20:00	Ceres Org Seaweed Multipack 8x2g	t	16	6.5	2	131	1
1050	2022-09-27 21:17:00	Macro FR Chciken Thigh Cutlet	f	0.604	7.13	1	58	1
1051	2022-09-27 21:17:00	Fresh Ginger	f	0.032	0.5	1	47	1
1055	2022-09-27 21:17:00	Doritos Corn Chips Original 170g	f	510.00	5.49	2	128	1
1056	2022-09-27 21:17:00	Sigol Seaweed Snack Olive Oil 4g 3pk	f	12	2.2	2	131	1
1057	2022-09-27 21:17:00	CD Premium Beef Mince REDUCED	f	0.5	9.62	1	18	1
1058	2022-09-27 21:17:00	CD Prime Beef Mince 1kg REDUCED	f	2	28.08	1	18	1
1061	2022-10-27 21:29:00	Whittakers Block Cocoa Dark 72% 250g	f	250	4.75	2	17	2
1063	2022-10-27 21:29:00	Avocado. Large Loose	f	3	2.07	7	24	2
1064	2022-10-27 21:29:00	Capsicum Loose	f	3	5.00	7	25	2
1065	2022-10-27 21:29:00	Cucumber Telegraph	f	2	3.58	7	46	2
1067	2022-10-27 21:29:00	Fruzio Mixed Berries 1 kg	f	1.00	10.79	1	150	2
1072	2022-10-30 22:22:00	Macro FR Chciken Thigh Fillet	f	0.639	12.96	1	58	1
1073	2022-10-30 22:22:00	CD Chicken Cutlet 	f	0.986	13.8	1	54	1
1409	2023-03-30 23:45:00	Albert's Eggs 12 Pack weighed	f	0.873	8.5	1	173	11
5	2021-06-17 04:41:00	Ceres Organics tomato paste	t	1140	16.20	2	5	1
15	2021-06-22 23:31:00	CD Eggs Sz7 6 pk Special x 2	f	744	5.3	2	6	1
1410	2023-03-30 23:45:00	Jack Links Jerky Original Beef 25g	f	25	3.9	2	186	11
24	2021-06-30 08:41:00	Otaika Valley Size 7 12 pack	f	744	7	2	6	1
26	2021-06-30 23:20:00	Ceres Organic Tomato Paste 190g	f	1140	14.94	2	5	2
51	2021-08-05 05:33:00	Coulston Hill Eggs Free Range Mixed 12pk x2	f	1164	10.98	2	6	2
248	2021-12-19 03:20:00	Bananas Conventional	f	0.626	1.87	1	4	13
291	2021-11-11 01:02:00	Ceres Organic Tomato Paste 190g	t	760.00	9.96	2	5	2
462	2022-01-31 23:07:00	Ceres Organic Tomato Paste 190g	t	570.00	7.47	2	5	2
497	2022-02-22 00:00:00	Bananas Conventional	f	1.696	4.9	1	4	2
498	2022-02-22 00:00:00	Bananas Conventional	f	0.176	0.51	1	4	2
578	2022-03-15 00:29:00	Bananas Cavendish	f	0.777	2.56	1	4	1
626	2022-03-28 22:16:00	Bananas Conventional	f	0.765	1.9	1	4	18
658	2022-04-17 23:25:00	Bananas Cavendish	f	1.152	2.29	1	4	1
702	2022-05-10 22:22:00	Bananas Conventional	f	1.286	3.72	1	4	2
703	2022-05-10 22:22:00	Bananas Conventional	f	0.276	0.8	1	4	2
723	2022-05-24 21:00:00	Bananas Conventional	f	1.2	3.96	1	4	1
742	2022-05-31 22:56:00	Onions Brown Loose	f	0.397	1.19	1	1	1
746	2022-05-31 22:56:00	Bananas Cavendish	f	2.677	9.37	1	4	1
764	2022-06-21 23:33:00	Bananas Cavendish	f	1.272	4.2	1	4	1
782	2022-06-16 00:54:00	Bananas Conventional	f	0.781	2.26	1	4	2
784	2022-06-16 00:54:00	Potatoes White Washed	f	1.206	3.36	1	2	2
803	2022-06-09 01:39:00	Bananas Conventional	f	1.521	4.4	1	4	2
1039	2022-10-27 00:20:00	Bananas Cavendish	f	0.842	3.24	1	4	1
1074	2022-10-30 22:22:00	OSM bars chocolate 6 pieces 480g NET 	f	6	15.40	7	67	1
1076	2022-10-30 22:22:00	CD Prime Beef Mince 1kg	f	1	15.41	1	18	1
1077	2022-08-29 00:00:00	Albert's Eggs Size J 20pk	f	1460	7.9	2	173	11
1078	2022-09-07 00:00:00	Albert's Eggs Size J 20pk	f	1460	7.9	2	173	11
1079	2022-09-12 00:00:00	Albert's Eggs Size J 20pk	f	1460	8.5	2	173	11
1080	2022-09-20 00:00:00	Albert's Eggs Size J 20pk	f	1460	8.5	2	173	11
1081	2022-08-19 00:00:00	The Good Oil Sunflower Oil 1L	f	1	10	3	187	22
1082	2022-11-07 23:00:00	Albert's Eggs Size J 20pk 1430g	f	1430	9.5	2	173	11
1084	2022-11-06 20:52:00	FOS Olives Pitted Green 30g	f	120.00	1.96	2	183	23
1085	2022-11-06 20:52:00	FOS Olives Pitted Kalamata Thyme 30g	f	120.00	1.96	2	183	23
1086	2022-11-06 20:52:00	Tasti Fruit Bars Banana 140g	f	280	4	2	188	23
1087	2022-11-06 20:52:00	Olly Garlic and Basil Olives 50g	f	100	1.78	2	183	23
1088	2022-11-06 20:52:00	Green and Black Smooth Dark Mint 90g	f	90	2	2	189	23
1089	2022-11-06 20:52:00	Tasti Mango Carrot Balls 180g	f	1620.00	25.11	2	182	23
1091	2022-11-06 20:52:00	Tasti Fruit Balls Banana Spinach 180g	f	180	2.79	2	182	23
1092	2022-11-06 20:52:00	Key Dairy Organic Whole Milk Powder 900g	t	900	10	2	190	23
1093	2022-11-06 20:52:00	Arnes Puree Tomatoes 390g	f	1170.00	2.97	2	41	23
1097	2022-11-13 06:22:00	CD Butter Salted 500g	f	500	4.9	2	12	1
1098	2022-11-13 06:22:00	Essentials Butter Salted 500g	f	500	4.9	2	12	1
1099	2022-11-13 06:22:00	Mainland Cheese Vintage 250g	f	250	8.5	2	21	1
1101	2022-11-06 22:50:00	ETA Ripples Ready Salted 150g	f	150	1.5	2	149	2
1102	2022-11-06 22:50:00	Kiwi Blue Water 1.5L 4pk	f	6.00	3.30	3	55	2
1103	2022-11-06 22:50:00	OSM bars chocolate 6 pieces 507g NET 	f	507.00	15.49	2	67	2
1104	2022-11-06 22:50:00	Pams Peach Slices in Juice 820g	f	2460.00	9.69	2	104	2
1106	2022-11-06 22:50:00	Value Tomatoes Chopped in Juice 400g	f	9600.00	16.56	2	41	2
1107	2022-11-06 22:50:00	Value Tomatoes Chopped in Juice 400g	f	4800.00	8.28	2	41	2
1108	2022-11-06 22:50:00	Whittakers Block Cocoa Dark 72% 250g	f	500	9.5	2	17	2
1110	2022-11-06 22:50:00	NZ Snapper Heads	f	0.912	6.37	1	30	2
1112	2022-11-06 22:50:00	Avocado. Large Loose	f	5	3.95	7	24	2
1114	2022-11-06 22:50:00	Cabbage Green Whole	f	1	7.99	7	60	2
1116	2022-11-06 22:50:00	Cucumber Telegraph	f	2	3.58	7	46	2
42	2021-07-27 04:29:00	Heyden Farms Free Range Sz 7 18 pk	f	1.116	10	1	6	1
45	2021-07-27 04:29:00	Countdown Free Range Sz 6 6pk Short Date Sale x 2	f	636	5.84	2	6	1
87	2021-08-12 01:33:00	CD Free Range Eggs Size 8 6pk Reduced Price	f	1632	10.84	2	6	1
89	2021-08-19 01:56:00	Heyden Farms FR Organic Eggs Mixed Grade 10pk	t	485	8.99	2	6	2
102	2021-08-19 01:08:00	Woodlands Free Range Size 6 10 pk	f	530	4.90	2	6	1
107	2021-07-19 21:35:00	Countdown Free Range Sz 7 6pk Reduced	f	372	2.10	2	6	1
108	2021-07-19 21:35:00	Big Paddock Free Range Eggs Mixed 10pk	f	485	5	2	6	1
112	2021-08-27 05:14:00	Countdown Free Range Sz 7 6pk	f	372.00	4.2	2	6	1
116	2021-07-14 22:30:00	Otaika Valley Size 7 12 pack Reduced	f	1488.00	13.60	2	6	1
131	2021-11-15 19:44:00	Woodland Free Range Eggs Sz6 18pk	f	954	8.5	2	6	1
152	2021-11-23 00:42:00	Countdown Free Range Eggs, Mixed 20 pk	f	970	9.50	2	6	1
154	2021-11-23 00:42:00	Countdown Free Range Sz 7 12pk	f	744	6.9	2	6	1
250	2021-12-20 23:18:00	Otaika Valley Size 7 12 pack	f	2976.00	27.96	2	6	2
285	2021-11-03 23:13:00	Woodland Free Range Eggs Sz6 18pk	f	954.00	8.50	2	6	1
292	2021-11-11 01:02:00	Otaika Valley Size 7 12 pack	f	744	6.99	2	6	2
293	2021-11-11 01:02:00	Otaika Valley Sz 8 10pk 675g	f	1350.00	12.58	2	6	2
816	2022-07-07 23:06:00	Bananas Conventional	f	1.051	3.04	1	4	2
820	2022-07-07 23:06:00	Onions Brown Loose	f	0.271	0.51	1	1	2
837	2022-07-08 00:00:00	Potatoes White Washed	f	1.107	3.31	1	2	1
865	2022-07-29 05:28:00	Bananas Cavendish	f	0.837	2.85	1	4	1
870	2022-07-19 00:06:00	Bananas Conventional	f	1.071	3.1	1	4	2
872	2022-07-19 00:06:00	Onions Brown Loose	f	0.251	0.5	1	1	2
888	2022-08-04 22:14:00	Bananas Dole	f	1.14	3	1	4	7
889	2022-08-04 22:14:00	Local Spray Free Potatoes	f	1.5	5	1	2	7
895	2022-08-04 22:14:00	Local Spray Free Onions	f	0.386	2	1	1	7
1117	2022-11-06 22:50:00	Garlic NZ	f	0.137	3.15	1	49	2
1118	2022-11-06 22:50:00	Fresh Ginger	f	0.201	1.61	1	47	2
1120	2022-11-06 22:50:00	Mandarins Loose NZ	f	2.316	12.71	1	93	2
1123	2022-11-06 22:50:00	The Berry Fix Frozen Blueberries 1.8kg	f	1.8	15.99	1	101	2
1124	2022-11-22 21:40:00	Paprika Bulk Bin	f	0.025	0.75	1	142	4
1127	2022-11-22 21:40:00	Organic Tumeric	t	300	9.99	2	139	4
1129	2022-11-20 03:43:00	Ceres Vegan Garlic Aoli 235g	t	0.235	2	1	105	23
1130	2022-11-20 03:43:00	Ceres Organic Mayo Vegan 235g	t	0.235	2	1	105	23
1131	2022-11-20 03:43:00	Tasti Fruit Balls Banana Spinach 180g	f	0.180	2.79	1	182	23
1132	2022-11-20 03:43:00	Barnicoat Frozen Strawberries 1kg	f	1	7.99	1	102	23
1431	2023-04-02 04:29:00	Fresh Ginger	f	0.127	2.09	1	47	1
1133	2022-11-20 03:43:00	SM Blueberries 1 kg	f	1	9.99	1	101	23
1139	2022-11-14 23:00:00	Albert's Eggs Size J 20pk 1430g	f	1.43	9.5000	1	173	11
1140	2022-11-20 23:00:00	Albert's Eggs Size J 20pk 1430g	f	1430	9.5	2	173	11
1141	2022-11-04 23:00:00	Loose Mandarins	f	1	4.89	1	93	25
1142	2022-10-25 23:00:00	Albert's Eggs Size J 20pk 1430g	f	1430	9.5	2	173	11
1143	2022-11-27 23:00:00	Albert's Eggs Size J 20pk 1430g	f	1430	9.5	2	173	11
1147	2022-11-20 21:15:00	Fresh Ginger	f	0.067	0.87	1	47	1
1148	2022-11-20 21:15:00	Kumara Orange	f	0.807	1.78	1	10	1
1149	2022-11-20 21:15:00	Bananas Cavendish	f	1.227	4.85	1	4	1
1150	2022-11-20 21:15:00	Kumara Orange	f	0.947	2.08	1	10	1
1151	2022-11-20 21:15:00	MV Beef Sausages 9s 580g	f	0.58	7	1	116	1
1153	2022-11-20 21:15:00	Angus Beef Mince 350g	f	1.05	19.77	1	18	1
1154	2022-11-20 21:15:00	CD Butter salted 500g	f	0.5	5.4	1	12	1
1155	2022-11-20 21:15:00	Mckenzies Soup Red Lentils 375g	f	0.375	2.7	1	72	1
1157	2022-11-20 21:15:00	Essentials Coconut Cream 400 mL	f	2000.00	7.50	4	15	1
1161	2022-11-20 21:15:00	ETA Ripples Ready Salted 150g	f	450.00	4.98	2	149	1
1163	2022-11-20 21:15:00	Cucumber Telegraph	f	1	2.2	7	46	1
1164	2022-11-20 21:15:00	Capsicum Odd Bunch 750g	f	750	5	2	25	1
1165	2022-12-05 23:00:00	Albert's Eggs Size J 20pk 1430g	f	1430	9.5000	2	173	11
1166	2022-11-29 20:30:00	Mainland Cheese Vintage 500g	f	500	14	2	21	1
1432	2023-04-02 04:29:00	Mrs. Higgins Cookie Chnky Choc Chip 100g	f	100	2.3	2	222	1
1433	2023-04-02 04:29:00	Kapiti Boysenberry 4pk x 105mL	f	420	7.5	4	33	1
1434	2023-04-02 04:29:00	CD Still Spring Water 1.5L	f	1.5	1.1	3	55	1
1435	2023-04-02 04:29:00	Alpine Cheese Tasty 1 kg	f	1	17.9	1	35	1
1436	2023-04-02 04:29:00	Tasti Fruit Balls Apple 207g	f	207	5.5	2	182	1
1437	2023-04-02 04:29:00	Ceres Salt & Vinegar Multipack 8x2g	t	16	5.5	2	131	1
1438	2023-04-02 04:29:00	Cucumber Telegraph	f	2	4	7	46	1
1439	2023-04-02 04:29:00	Wahiki Coconut Boysenberry 480mL	f	480	9.5	4	33	1
1440	2023-04-02 04:29:00	Mainland Cheese Vintage 250g	f	250	8.5	2	21	1
1441	2023-04-02 04:29:00	Capsicum Loose	f	1	2.49	7	25	1
1442	2023-04-02 04:29:00	Verkerks Wagyu Salami 100g	f	100.00	9.99	2	162	1
1443	2023-04-02 04:29:00	Hansells Mandarin Lime&Bitters 750mL	f	750	6.5	4	135	1
1444	2023-04-02 04:29:00	Hansells LemonRasbery & Elderberry 750mL	f	0.75	6.5	3	135	1
1445	2023-04-02 04:29:00	Arnotts Cruskits 250g	f	250	6	2	3	1
1446	2023-04-02 04:29:00	Chantal Organic Onion Bag 1kg	t	1	6.99	1	1	1
6	2021-06-22 22:59:00	Pams White Vinegar 2L	f	2	3.79	3	8	2
7	2021-06-22 22:59:00	NZ Trevally Fillets	f	590	14.04	2	7	2
8	2021-06-22 22:59:00	Apples Pink Lady Large	f	1.201	1.55	1	9	2
32	2021-06-30 23:20:00	Hoki Fillets Fresh	f	0.768	9.82	1	7	2
33	2021-06-30 23:20:00	Apples Braeburn	f	0.961	3.55	1	9	2
48	2021-07-29 06:26:00	Organic Jazz Apple 1 kg bag	t	1	5.50	1	9	1
56	2021-08-05 05:33:00	Apples Cripps Pink Lady Medium	f	1.136	1.12	1	9	2
57	2021-08-05 05:33:00	Apples Fuji	f	1.026	0.81	1	9	2
92	2021-08-19 01:56:00	Apples Cripps Pink Lady Medium	f	1.736	1.72	1	9	2
105	2021-07-19 21:35:00	Apples 2kg Odd Bunch	f	2	4.30	1	9	1
110	2021-08-27 05:14:00	Apple Rose Medium	f	0.257	1.16	1	9	1
114	2021-07-14 22:30:00	SweeTango loose apples	f	1.442	7.93	1	9	1
122	2021-07-20 00:18:00	NZ Hoki Fillets	f	0.474	6.06	1	7	2
128	2021-11-15 19:44:00	Apples Royal Gala	f	0.967	4.06	1	9	1
138	2021-11-15 20:10:00	Pam's Organic Fuji Apples 1 kg	t	1	3.99	1	9	2
173	2021-11-29 20:45:00	Apples 2 kg Odd Bunch	f	2	4.90	1	9	1
180	2021-11-15 23:00:00	Hoki Fillets Fresh	f	0.548	10.38	1	7	9
214	2021-12-07 23:00:00	No Label Jumbo dozen eggs	f	800	5	2	6	11
229	2021-12-12 22:19:00	Countdown Free Range Sz 7 12pk	f	1488.00	13.80	2	6	1
209	2021-12-04 23:11:00	Pam's Organic Fuji Apples 1 kg	t	1	3.99	1	9	2
223	2021-12-12 22:19:00	Apples Royal Gala	f	0.947	4.74	1	9	1
310	2021-12-27 03:50:00	Pam's Organic Fuji Apples 1 kg	t	1	3.99	1	9	2
330	2022-01-11 02:54:00	Apples Braeburn	f	1.881	7.13	1	9	2
348	2021-10-22 00:02:00	Apples Royal Gala	f	1.272	4.45	1	9	1
370	2021-10-28 02:33:00	Macro Organic Apple 1 kg bag	t	1	4.5	1	9	1
375	2021-10-31 01:06:00	Apples Braeburn	f	1.436	5.3	1	9	2
471	2022-01-31 23:07:00	Apples Royal Gala	f	1.016	3.04	1	9	2
644	2022-04-12 22:37:00	Apples Royal Gala	f	0.952	2.86	1	9	1
680	2022-04-20 02:34:00	Apples NZ Queen	f	1.206	1.19	1	9	2
700	2022-05-10 22:22:00	Apples Dazzle NZ	f	1.571	1.56	1	9	2
710	2022-05-18 02:05:00	Apple Rose Medium	f	0.837	2.93	1	9	1
777	2022-06-21 23:33:00	Apples 2 kg Odd Bunch	f	2	3	1	9	1
908	2022-07-25 03:40:00	Bananas Conventional	f	0.712	2.42	1	4	1
927	2022-08-11 22:17:00	Onions Brown Loose	f	0.306	0.58	1	1	2
1168	2022-11-29 20:30:00	Cucumber Telegraph	f	1	2.2	7	46	1
1172	2022-11-29 20:30:00	CD NZ chicken thigh cutlets	f	0.922	12.9	1	54	1
1173	2022-11-29 20:30:00	Essentials Coconut Cream 400 mL	f	800	3	4	15	1
1174	2022-11-29 20:30:00	WW White Sugar 1.5kg	f	3	6	1	23	1
1175	2022-11-29 20:30:00	Essentials Chocolate Chips Dark 250g	f	0.25	1.5	1	19	1
1177	2022-11-29 20:30:00	OSM muesli bars chocolate honey 480g 6pk	f	480	15.2	2	67	1
1178	2022-11-29 20:30:00	Whittakers Block Cocoa Dark 72% 250g	f	500	9.6	2	17	1
1179	2022-12-01 22:01:00	Ceres Organic Apple Cider Vinegar 750mL	t	0.75	6.49	3	27	2
1181	2022-12-01 22:01:00	Whittakers Block Cocoa Dark 72% 250g	f	250	4.75	2	17	2
1182	2022-12-01 22:01:00	Bananas Conventional	f	0.715	2.35	1	4	2
1183	2022-12-01 22:01:00	Anchor butter 500g	f	0.5	5.09	1	12	2
1184	2022-12-01 23:00:00	Oats, Jumbo Rolled 2kg bag	t	2	3.96	1	164	6
1186	2022-12-01 23:00:00	Sultanas, Bulk 2.5 kg bag	t	2.50	26.61	1	65	6
1187	2022-12-01 23:00:00	Quinoa, White, 3.5 kg bag	t	3.5	35.2	1	63	6
1188	2022-12-01 23:00:00	Coconut Sugar, Ceres 3kg	t	3.00	25.51	1	167	6
1189	2022-12-01 23:00:00	Ground Cinnamon, Ceres split 1kg bag	t	0.50	12.13	1	165	6
1190	2022-12-01 23:00:00	Licorice and Cinnamon Tea, Pukka 20 count box 40g NET	t	40.00	15.75	5	76	6
1191	2022-12-01 23:00:00	Buckwheat Hulled, 25 kg share bag	t	16.5	83.28	1	123	6
1196	2022-12-20 20:44:00	Mandarins Afourer	f	0.792	5.54	1	93	1
1200	2022-12-20 20:44:00	Essentials Coconut Cream 400 mL	f	1.6	6	3	15	1
1205	2022-12-20 20:44:00	Capsicum Odd Bunch 750g	f	0.75	5	1	25	1
1208	2022-12-11 22:24:00	Bananas Cavendish	f	0.727	2.87	1	4	1
1209	2022-12-11 22:24:00	Fresh Ginger	f	0.242	3.14	1	47	1
1210	2022-12-11 22:24:00	CD Chicken Cutlet Medium	f	0.887	12.42	1	54	1
1211	2022-12-11 22:24:00	CD Chicken Cutlets Small	f	0.638	8.93	1	54	1
1212	2022-12-11 22:24:00	Bananas Cavendish	f	0.312	1.23	1	4	1
1213	2022-12-11 22:24:00	Onions Brown Loose	f	0.587	2.34	1	1	1
1214	2022-12-11 22:24:00	Cucumber Lebanese	f	1	2	7	46	1
1215	2022-12-11 22:24:00	WW Crinkle Cut Chips Salted 150g	f	300.00	3.4	2	149	1
1216	2022-12-11 22:24:00	WW Raisins 375g	f	375	3.2	2	65	1
1217	2022-12-11 22:24:00	WW Dates Pitted 500g	f	500	2.8	2	78	1
1218	2022-12-11 22:24:00	Essentials Coconut Cream 400 mL	f	1.6	6	3	15	1
1219	2022-12-11 22:24:00	Ocean Blue Smoked Salmon 180g	f	180	12	2	129	1
1221	2022-11-04 00:07:00	Garlic NZ	f	0.072	2.88	1	49	1
1222	2022-11-04 00:07:00	Mandarins Afourer	f	0.872	5.23	1	93	1
1224	2022-11-04 00:07:00	Essentials Coconut Cream 400 mL	f	1.2	4.5	3	15	1
1226	2022-11-04 00:07:00	Whittakers Block Cocoa Dark 72% 250g	f	250	5.3	2	17	1
1227	2022-11-04 00:07:00	Capsicum Loose	f	3	3	7	25	1
1228	2022-11-04 00:07:00	Cucumber Lebanese	f	1	2.19	7	46	1
1229	2022-11-04 00:07:00	Odd Bunch Avocados 1kg	f	1	4.5	1	24	1
1230	2022-11-04 00:07:00	Apples Pink Kids 1 kg	f	1	4	1	9	1
1231	2022-11-04 00:07:00	Macro Organic Whole Egg Mayo 440g	t	440	6.90	2	105	1
1232	2022-12-22 21:43:00	Whittakers Block Cocoa Dark 72% 250g	f	500	9.5	2	17	2
1233	2022-12-22 21:43:00	Mandarins Afourer	f	0.48	2.64	1	93	2
1234	2023-01-03 02:19:00	Barnicoat Frozen Strawberries 1kg	f	1	7.99	1	102	23
1235	2023-01-03 02:19:00	Mexicano Corn Chips Sourcream 170g	f	170	1.49	2	56	23
1236	2023-01-03 02:02:00	Macro Free Range Chicken Drumsticks	f	1.082	11.44	1	79	1
1239	2023-01-03 02:02:00	WW Black Sliced Olives 430g	f	430	3.4	2	113	1
1240	2023-01-03 02:02:00	Essentials Coconut Cream 400 mL	f	1.6	6	3	15	1
9	2021-06-22 22:59:00	Kumara Orange	f	851	2.54	2	10	2
37	2021-06-30 23:20:00	Kumara Orange	f	1.136	2.83	1	10	2
60	2021-08-05 05:33:00	Kumara Orange	f	2.211	4.40	1	10	2
207	2021-12-04 23:11:00	Kumara Orange	f	1.451	2.67	1	10	2
263	2021-12-20 23:18:00	Kumara Orange	f	1.401	4.19	1	10	2
299	2021-11-11 01:02:00	Kumara Orange	f	0.61	1.83	1	10	2
304	2021-10-25 19:31:00	Apples Braeburn	f	0.651	2.6	1	9	13
334	2022-01-11 02:54:00	Kumara Orange	f	0.661	1.98	1	10	2
365	2021-10-28 02:33:00	Kumara Orange	f	1.727	5.70	1	10	1
406	2022-01-17 20:17:00	Kumara Orange	f	0.507	1.77	1	10	1
438	2022-01-24 21:21:00	Kumara Orange	f	0.967	3.38	1	10	1
476	2022-01-31 23:07:00	Kumara Red	f	0.661	1.98	1	10	2
630	2022-04-05 02:37:00	Apples Royal Gala	f	1	1.49	1	9	18
706	2022-05-10 22:22:00	Kumara Orange	f	1.661	4.97	1	10	2
747	2022-05-31 22:56:00	Apples 2kg Odd Bunch	f	2	4.99	1	9	1
781	2022-06-16 00:54:00	Apples NZ Queen	f	1.966	2.54	1	9	2
802	2022-06-09 01:39:00	Apples Dazzle NZ	f	1.461	1.88	1	9	2
829	2022-07-11 23:13:00	Apples Cripps Pink Lady Medium	f	0.926	1.19	1	9	2
847	2022-07-08 00:00:00	Apples Royal Gala 1.5kg bag	f	1.5	5.99	1	9	1
854	2022-07-18 23:20:00	Apples 2kg Odd Bunch	f	2	4.99	1	9	1
864	2022-07-29 05:28:00	Apple Rose Medium	f	0.712	2.71	1	9	1
875	2022-07-01 00:00:00	Apples Braeburn Organic	t	1	4	1	9	1
880	2022-07-01 00:00:00	Arnotts Vita-weat Cracked Pepper 250g	f	0.25	2.5	1	3	1
881	2022-07-01 00:00:00	Countdown Free Range Sz 7 12pk	f	0.744	6.9	1	6	1
899	2022-08-09 22:45:00	WW Thin Rice Cracker Plain 100g	f	0.2	2.4	1	3	1
903	2022-08-09 22:45:00	Short date bananas on special	f	4	6	1	4	1
932	2022-08-04 23:12:00	Apples Braeburn Organic	t	2.627	5.25	1	9	1
940	2022-08-04 23:12:00	Apples 2kg Odd Bunch	f	2	4.99	1	9	1
1032	2022-10-21 06:04:00	Apples Royal Gala	f	0.787	2.75	1	9	1
1062	2022-10-27 21:29:00	Apples Royal Gala	f	0.131	0.52	1	9	2
1159	2022-11-20 21:15:00	Apples 2 kg Odd Bunch	f	2	5.49	1	9	1
1170	2022-11-29 20:30:00	Apples 2kg Odd Bunch	f	2	3	1	9	1
1207	2022-12-11 22:24:00	Apples Cripps Pink Lady	f	1.747	6.11	1	9	1
1237	2023-01-03 02:02:00	Bananas Cavendish	f	0.487	1.92	1	4	1
1238	2023-01-03 02:02:00	Arnotts Vita-weat Cracked Pepper 250g	f	0.75	9.9	1	3	1
1242	2023-01-02 23:00:00	Albert's Eggs Size J 20pk 1430g	f	1430	9.9	2	173	11
1243	2023-01-01 03:40:00	Tararua Salted Butter 500g	f	2	16	1	12	20
1244	2023-02-07 21:54:00	Chickpeas Bulk Bin	f	1.59	14.15	1	176	4
1246	2023-02-07 22:04:00	Cabbage Green Medium	f	1	4.99	7	60	26
1247	2023-02-07 22:04:00	Capsicum mixed bag	f	0.5	4.99	1	25	26
1249	2023-02-05 23:00:00	Albert's Eggs Size 7 30pk 1860g	f	1.86	14.5	1	173	11
1255	2022-12-26 01:58:00	Juicies Wildberry Frozen 10x100mL	f	1000.00	6.5	4	181	1
1256	2022-12-26 01:58:00	Cookie Time 9 Pack Choc Chip 630g	f	630.00	12	2	178	1
1257	2022-12-26 01:58:00	CD FR Eggs Sz 7 12 pack	f	0.744	8.2	1	6	1
1258	2022-12-26 01:58:00	Mexicano Corn Chips Natural 300g	f	300	3.5	2	56	1
1259	2022-12-26 01:58:00	Essentials Coconut Cream 400 mL	f	1.2	4.5	3	15	1
1260	2022-12-26 01:58:00	Quick Sale Banana Packs	f	4	6	1	4	1
1261	2022-12-26 01:58:00	Cabbage Red Whole	f	1	6.49	7	60	1
1262	2023-02-01 23:00:00	CD Cheese block Tasty 1kg	f	1.00	18.9	1	35	1
1411	2023-03-23 21:59:00	ETA Ripples Ready Salted 150g	f	150	1.85	2	149	2
10	2021-06-22 22:59:00	Mushrooms white button	f	157	1.73	2	11	2
1412	2023-03-23 21:59:00	T/Colledge Vanilla Exract 100 mL FairTrade	f	100	8.99	4	28	2
1413	2023-03-23 21:59:00	Value Tomatoes Chopped in Juice 400g	f	9.60	18.96	1	41	2
1414	2023-03-23 21:59:00	Apples NZ Queen	f	0.4	0.4	1	9	2
38	2021-06-30 23:20:00	Mushrooms White Button Loose	f	0.182	2	1	11	2
1415	2023-03-23 21:59:00	Capsicum Loose	f	2	2.98	7	25	2
1416	2023-03-23 21:59:00	Carrots, Loose	f	1.29	3.73	1	14	2
41	2021-07-27 04:29:00	Mushrooms Button Loose	f	0.318	4.13	1	11	1
1417	2023-03-23 21:59:00	Cucumber Telegraph	f	1	1.49	7	46	2
1418	2023-03-23 21:59:00	Lamb Pieces Bone In	f	0.882	9.69	1	219	2
62	2021-08-05 05:33:00	Mushrooms White Button	f	0.162	1.78	1	11	2
95	2021-08-19 01:56:00	Mushrooms White Button	f	0.192	2.40	1	11	2
124	2021-07-20 00:18:00	Mushrooms White Button Loose	f	0.192	2.11	1	11	2
127	2021-11-15 19:44:00	Mushrooms Button Loose	f	0.243	3.16	1	11	1
148	2021-11-23 00:42:00	Mushrooms Button Loose	f	0.233	3.03	1	11	1
162	2021-11-29 20:45:00	Mushrooms Button Loose	f	0.223	2.90	1	11	1
208	2021-12-04 23:11:00	Mushrooms Button Loose	f	0.227	2.72	1	11	2
218	2021-12-12 22:19:00	Mushrooms Button Loose	f	228	2.96	2	11	1
264	2021-12-20 23:18:00	Mushrooms Button Loose	f	0.347	4.33	1	11	2
288	2021-11-03 23:00:00	Mushrooms Button Loose	f	0.207	2.59	1	11	2
300	2021-11-11 01:02:00	Mushrooms Button Loose	f	0.24	2.06	1	11	2
309	2021-12-27 03:50:00	Mushrooms Button Loose	f	0.087	1.09	1	11	2
318	2022-01-07 01:28:00	Mushrooms Button Loose	f	0.293	3.81	1	11	1
336	2022-01-11 02:54:00	Mushrooms Button Loose	f	0.197	2.46	1	11	2
345	2021-10-22 00:02:00	Mushrooms Button Loose	f	0.238	3.09	1	11	1
389	2021-12-31 03:00:00	Mushrooms Button Loose	f	0.21	2.73	1	11	1
405	2022-01-17 20:17:00	Mushrooms Button Loose	f	0.353	4.94	1	11	1
436	2022-01-24 21:21:00	Mushrooms Button Loose	f	0.198	2.77	1	11	1
477	2022-01-31 23:07:00	Mushrooms Button Loose	f	0.262	3.27	1	11	2
502	2022-02-22 00:00:00	Mushrooms Button Loose	f	0.327	3.92	1	11	2
510	2022-02-08 01:03:00	Mushrooms Button Loose	f	0.253	3.54	1	11	1
523	2022-02-15 01:54:00	Mushrooms Button Loose	f	0.128	1.79	1	11	1
549	2022-02-28 22:11:00	Mushrooms Button Loose	f	0.203	2.84	1	11	1
572	2022-03-07 21:11:00	Mushrooms Button Loose	f	0.252	3.02	1	11	2
608	2022-03-22 22:08:00	Mushrooms Button Loose	f	0.252	3.02	1	11	2
642	2022-04-12 22:37:00	Mushrooms Button Loose	f	0.298	4.17	1	11	1
682	2022-04-20 02:34:00	Mushrooms Button Loose	f	0.352	3.52	1	11	2
707	2022-05-10 22:22:00	Mushrooms Button Loose	f	0.177	2.12	1	11	2
709	2022-05-18 02:05:00	Mushrooms Button Loose	f	0.163	2.28	1	11	1
725	2022-05-24 21:00:00	Mushrooms Button Loose	f	0.2	2.8	1	11	1
897	2022-08-09 22:45:00	Kumara Orange	f	0.822	3.29	1	10	1
926	2022-08-11 22:17:00	Kumara Orange	f	0.961	1.91	1	10	2
931	2022-08-04 23:12:00	Kumara Orange	f	0.297	1.13	1	10	1
954	2022-09-15 22:30:00	Bananas Conventional	f	0.8	2.88	1	4	1
956	2022-09-15 22:30:00	Kumara Orange	f	0.52	1.14	1	10	1
957	2022-09-15 22:30:00	Onions Brown Loose	f	0.3	0.81	1	1	1
958	2022-09-15 22:30:00	Apples 2kg Odd Bunch	f	2	3.5	1	9	1
12	2021-06-22 22:59:00	Anchor butter 500g	f	500	4.80	2	12	2
14	2021-06-22 23:31:00	Pumpkin Butternut Whole Ea	f	1	3	7	13	1
16	2021-06-22 23:31:00	Macro Organic Carrots 1 kg	t	1	6	1	14	1
94	2021-08-19 01:56:00	Carrots, Loose	f	0.851	0.84	1	14	2
106	2021-07-19 21:35:00	Carrots, 1.5 kg Odd Bunch	f	1.5	2	1	14	1
139	2021-11-15 20:10:00	Anchor butter 500g	f	500.00	5.4	2	12	2
169	2021-11-29 20:45:00	Anchor butter 500g	f	500.00	5.8	2	12	1
187	2021-10-30 23:00:00	Local Carrot Bunch	f	1	2	6	14	7
210	2021-12-04 23:11:00	Anchor butter 500g	f	1500.00	11.97	2	12	2
261	2021-12-20 23:18:00	Carrots, Loose	f	0.626	1.25	1	14	2
268	2021-12-20 23:18:00	Anchor butter 500g	f	500	4.9	2	12	2
315	2021-12-27 03:50:00	Anchor butter 500g	f	1000	10	2	12	2
340	2022-01-11 02:54:00	Anchor butter 500g	f	2000	17.56	2	12	2
377	2021-10-31 01:06:00	Pams Butter 500g	f	500	4.89	2	12	2
574	2022-03-07 21:11:00	Anchor butter 500g	f	500	5.39	2	12	2
609	2022-03-22 22:08:00	Anchor butter 500g	f	500	5.4	2	12	2
624	2022-03-28 22:16:00	Mushrooms Button Loose	f	0.16	2.08	1	11	18
632	2022-04-05 02:37:00	Mushrooms Button Loose	f	0.145	1.88	1	11	18
639	2022-04-05 02:55:00	CD Butter Salted 500g	f	500	5.8	2	12	1
655	2022-04-12 22:37:00	CD Butter Salted 500g	f	500	5.8	2	12	1
683	2022-04-20 02:34:00	Anchor butter 500g	f	1000	10.80	2	12	2
691	2022-05-10 22:53:00	CD Butter Salted 500g	f	1000	11.60	2	12	1
719	2022-05-18 02:05:00	CD Butter Salted 500g	f	500	5.8	2	12	1
722	2022-05-24 21:00:00	CD Butter Salted 500g	f	500	5.4	2	12	1
766	2022-06-21 23:33:00	Mushrooms Button Loose	f	0.218	3.05	1	11	1
786	2022-06-16 00:54:00	Pams Butter 500g	f	2000.00	19.96	2	12	2
787	2022-06-09 23:27:00	Mushrooms Button Loose	f	0.15	2.14	1	11	1
792	2022-06-09 23:27:00	CD Butter Salted 500g	f	500	5.4	2	12	1
819	2022-07-07 23:06:00	Mushrooms Button Loose	f	0.187	2.24	1	11	2
871	2022-07-19 00:06:00	Mushrooms Button Loose	f	0.137	1.64	1	11	2
877	2022-07-01 00:00:00	Mushrooms Button Loose	f	0.2	2.8	1	11	1
887	2022-07-18 22:38:00	Tararua Salted Butter 500g	f	1.5	14.70	1	12	20
898	2022-08-09 22:45:00	Mushrooms Button Loose	f	0.188	2.63	1	11	1
952	2022-09-15 22:30:00	CD Butter Salted 500g	f	0.5	5.4	1	12	1
966	2022-09-15 22:23:00	Tararua Salted Butter 500g	f	1	7.94	1	12	20
979	2022-09-01 23:18:00	Mushrooms Button Loose	f	0.162	1.62	1	11	2
981	2022-09-01 23:18:00	Rolling Meadow Butter 500g	f	1	10.18	1	12	2
983	2022-08-31 23:36:00	Kumara Orange	f	2.172	4.78	1	10	1
984	2022-08-31 23:36:00	Bananas Cavendish	f	0.502	1.76	1	4	1
155	2021-11-23 00:42:00	Carrots, 1.5 kg Odd Bunch	f	1.5	3	1	14	1
321	2022-01-07 01:28:00	Carrots, 1.5 kg Odd Bunch	f	1.5	3	1	14	1
360	2021-10-22 00:02:00	Macro Org Carrots 1kg	t	1	6	1	14	1
364	2021-10-28 02:33:00	Carrots, Loose	f	0.832	2.49	1	14	1
451	2022-01-31 23:40:00	Macro Org Carrots 1kg	t	1	8	1	14	1
532	2022-02-15 01:54:00	Macro Org Carrots 1kg	t	1	8	1	14	1
570	2022-03-07 21:11:00	Carrots, Loose	f	0.601	1.68	1	14	2
694	2022-05-10 22:53:00	Carrots, 1.5 kg Odd Bunch	f	1.5	3	1	14	1
732	2022-05-24 21:00:00	Carrots, 1.5 kg Odd Bunch	f	1.5	3	1	14	1
788	2022-06-09 23:27:00	Carrots, 1.5 kg Odd Bunch	f	1.5	3	1	14	1
831	2022-07-11 23:13:00	Carrots, Loose	f	0.631	1.44	1	14	2
855	2022-07-18 23:20:00	Carrots, 1.5 kg Odd Bunch	f	1.5	3	1	14	1
878	2022-07-01 00:00:00	Carrots, 1.5 kg Odd Bunch	f	1.5	3	1	14	1
893	2022-08-04 22:14:00	Local Spray Free Carrots	f	0.73	3	1	14	7
924	2022-08-11 22:17:00	Carrots, Loose	f	0.786	1.8	1	14	2
977	2022-09-01 23:18:00	Carrots, Loose	f	1.061	2.11	1	14	2
1004	2022-09-22 21:12:00	Better Eggs Forest FR Mixed 10pk	f	485	4	2	6	2
1007	2022-09-22 21:12:00	Apples Cripps Pink Lady	f	0.906	1.8	1	9	2
1009	2022-09-22 21:12:00	Bananas Conventional	f	0.936	2.71	1	4	2
1011	2022-09-22 21:12:00	Carrots, Loose	f	1.096	2.18	1	14	2
1014	2022-09-22 21:12:00	Onions Brown Loose	f	0.451	0.81	1	1	2
1015	2022-09-22 21:12:00	Onions Brown Loose	f	0.466	0.83	1	1	2
1020	2022-08-26 00:00:00	Arnotts Vita-weat Cracked Pepper 250g	f	250	3.3	2	3	1
1100	2022-11-06 22:50:00	Ceres Organic Tomato Paste 190g	t	190	2.79	2	5	2
1109	2022-11-06 22:50:00	NZ Deep Sea Cod Fillets	f	0.432	12.52	1	7	2
1111	2022-11-06 22:50:00	Apples Royal Gala	f	1.081	4.31	1	9	2
1113	2022-11-06 22:50:00	Bananas Conventional	f	2.456	7.34	1	4	2
1119	2022-11-06 22:50:00	Kumara Orange	f	1.446	5.05	1	10	2
1121	2022-11-06 22:50:00	Mushrooms White Button	f	0.202	2.52	1	11	2
1122	2022-11-06 22:50:00	Onions Brown Loose	f	1.511	5.27	1	1	2
1171	2022-11-29 20:30:00	Carrots, 1.5 kg Odd Bunch	f	1.5	3.8	1	14	1
1223	2022-11-04 00:07:00	Carrots, 1.5 kg Odd Bunch	f	1.5	3.5	1	14	1
1263	2023-02-01 23:00:00	Verkerks Wagyu Salami 100g	f	100.00	7.99	2	162	1
1264	2023-02-01 23:00:00	Apples Royal Gala	f	1.1	5.48	1	9	1
1265	2023-02-01 23:00:00	Bananas Conventional	f	1	3.95	1	4	1
1266	2023-02-01 23:00:00	Mushrooms Button Loose	f	0.14	2.38	1	11	1
1267	2023-02-01 23:00:00	Onions Brown Loose	f	0.2	0.8	1	1	1
1268	2023-02-01 23:00:00	Carrots, 1.5 kg Odd Bunch	f	1.5	4	1	14	1
1270	2023-02-01 23:00:00	CD Beef Mince 82% 1kg	f	1	16.5	1	18	1
1271	2023-02-01 23:00:00	Essentials Coconut Cream 400 mL	f	400	1.5	4	15	1
1272	2023-02-01 23:00:00	WW Dates Pitted 500g	f	500	2.8	2	78	1
1274	2023-02-01 23:00:00	Ceres Org Seaweed Snack Nori 11.3g	f	11.3	4	2	131	1
1275	2023-02-01 23:00:00	Ceres Org Seaweed Multipack 8x2g	f	32.00	11	2	131	1
1276	2023-02-01 23:00:00	Jack Links Jerky Original Beef 50g	f	200.00	17.6	2	186	1
1277	2023-02-01 23:00:00	Jack links original beef sticks 12g x 6pk	f	72.00	5.5	2	186	1
1278	2023-02-01 23:00:00	OSM muesli bars chocolate honey 480g 6pk	f	960.00	32.00	2	67	1
1279	2023-02-01 23:00:00	Tasti fruit balls black currant 207g	f	207	5.5	2	182	1
1280	2023-02-01 23:00:00	Tasti smooshed berry cashew 207g	f	207	5	2	182	1
1281	2023-02-01 23:00:00	Whittakers Block Cocoa Dark 72% 250g	f	500	12	2	17	1
1283	2023-01-09 22:11:00	Onions Brown Loose	f	0.637	2.54	1	1	1
1033	2022-10-21 06:04:00	Bananas Cavendish	f	1.062	3.88	1	4	1
1036	2022-10-21 06:04:00	Bananas Cavendish	f	0.152	0.55	1	4	1
1046	2022-10-27 00:20:00	WW Thin Rice Cracker Salt&Ving 100g	f	100	1.5	2	3	1
1167	2022-11-29 20:30:00	Bananas Conventional	f	1	3.95	1	4	1
1254	2022-12-26 01:58:00	Arnotts Vita-weat Cracked Pepper 250g	f	0.25	3.3	1	3	1
1284	2023-01-09 22:11:00	Bananas Cavendish	f	1.032	4.08	1	4	1
1285	2023-01-09 22:11:00	Plums Classic Loose	f	0.33	2.31	1	85	1
1286	2023-01-09 22:11:00	Kiwifruit Green NZ	f	0.157	1.49	1	96	1
1287	2023-01-09 22:11:00	Kumara Orange X-large	f	1.382	3.04	1	10	1
1288	2023-01-09 22:11:00	Fresh Ginger	f	0.342	4.61	1	47	1
1289	2023-01-09 22:11:00	Bananas Cavendish	f	0.622	2.46	1	4	1
1290	2023-01-09 22:11:00	Loose Mandarins	f	0.172	1.55	1	93	1
1291	2023-01-09 22:11:00	Fresh N Fruity Mixed Berry 6pk	f	750.00	4.5	2	153	1
1292	2023-01-09 22:11:00	CD Beef Mince 82% 1kg	f	1	16.5	1	18	1
1293	2023-01-09 22:11:00	Juicies Tropical Frozen 10x100mL	f	1000.00	6.5	4	181	1
1294	2023-01-09 22:11:00	Lisas Hummus Gloriously Garlic 380g	f	380.00	6	2	158	1
1297	2023-01-09 22:11:00	Odd Bunch Avocados 1kg	f	1	6.5	1	24	1
1300	2023-01-09 22:11:00	Huntley & Palmers Rosemary Garlic Crackers	f	200	3.7	2	3	1
1301	2023-01-09 22:11:00	Whittakers Block Cocoa Dark 72% 250g	f	250	6	2	17	1
1302	2023-01-09 22:11:00	Tostitos Splash of Lime 175g	f	175	3	2	56	1
1303	2023-01-09 22:11:00	WW Crinkle Cut Chips Ready 150g	f	450.00	5.1	2	149	1
1306	2023-01-09 22:11:00	Mainland Cheese Tasty 700g	f	0.7	18.9	1	35	1
1307	2023-01-09 22:11:00	OSM muesli bars chocolate honey 480g 6pk	f	960.00	30.4	2	67	1
1308	2023-01-09 22:11:00	CD FR Eggs Sz 7 12 pack	f	744	8.2	2	6	1
1309	2023-01-09 22:11:00	WW Chocolate Drops Dark 200g	f	0.2	2.8	1	19	1
1311	2023-01-09 22:11:00	WW Black Sliced Olives 430g	f	430	3.4	2	113	1
1312	2023-01-09 22:11:00	WW White Sugar 1.5kg	f	1.5	3.3	1	23	1
1313	2023-01-09 22:11:00	Nice Natural Roasted Nut Bar TrailMix 6pk 192g	f	192	3	2	92	1
1315	2023-01-09 22:11:00	Mckenzies Soup Red Lentils 375g	f	0.375	2.7	1	72	1
1316	2023-01-12 23:00:00	Albert's Eggs Size 7 30pk 1860g	f	1.86	14.50	1	173	11
1317	2022-12-22 23:00:00	Fill Your Own Honey	f	4.2	42	1	77	16
1318	2022-12-12 23:00:00	Albert's Eggs Size J 20pk 1430g	f	1.430	9.5	1	173	11
1319	2022-12-21 23:00:00	Albert's Eggs Size J 20pk 1430g	f	1.43	9.5	1	173	11
1320	2022-11-17 23:00:00	Small Spray Free Cabbage	f	1	2	7	60	27
1321	2022-11-17 23:00:00	Small Spray Free Cucumber	f	1	3	7	46	27
1322	2022-11-17 23:00:00	Bunch of Spray Free Beetroot	f	1	5	6	32	27
1323	2023-02-13 23:15:00	CD Chicken Drumsticks Large	f	1.49	9.69	1	48	1
1324	2023-02-13 23:15:00	Bananas Cavendish	f	0.752	2.97	1	4	1
1325	2023-02-13 23:15:00	Fresh Ginger	f	0.252	3.4	1	47	1
1326	2023-02-13 23:15:00	Onions Brown Loose	f	0.457	1.82	1	1	1
1327	2023-02-13 23:15:00	CD Butter Salted 500g	f	1	9.8	1	12	1
1328	2023-02-13 23:15:00	Killinchy Gold Choc & Boysen 1L	f	1	10	3	33	1
1331	2023-02-13 23:15:00	Whittakers Block Cocoa Dark 72% 250g	f	250	5.3	2	17	1
1332	2023-02-13 23:15:00	Whittakers Block Rum & Raisin 250g	f	250	5.3	2	17	1
1333	2023-02-13 23:15:00	Quick Sale Mixed Apples	f	1.4	3	1	9	1
1335	2023-02-13 23:15:00	Arnotts Vita-weat Cracked Pepper 250g	f	500	6.6	2	3	1
1336	2023-01-09 23:00:00	Huntly Street Seller fresh strawberries	f	1.25	10	1	59	28
1337	2023-02-19 23:00:00	Albert's Eggs Size 7 30pk 1860g	f	1800	17.50	2	173	11
1338	2023-02-23 21:58:00	Exotic Foods Red Chilli Whole 190g	f	190.00	3.8900	2	184	2
1339	2023-02-23 21:58:00	Hoco Coconut Water 1L	f	2	7.38	3	53	2
1341	2023-02-23 21:58:00	Pams White Vinegar 2L	f	2.00	4.1	3	8	2
1342	2023-02-23 21:58:00	T/Colledge Vanilla Exract 100 mL FairTrade	f	100	9.79	4	28	2
1343	2023-02-23 21:58:00	Value Sultanas 400g	f	400	2.19	2	65	2
1344	2023-02-23 21:58:00	Value Tomatoes Chopped in Juice 400g	f	4.80	10.68	1	41	2
1345	2023-02-23 21:58:00	Whittakers Block Cocoa Dark 72% 250g	f	750	14.25	2	17	2
1346	2023-02-23 21:58:00	Hoki Fillets Fresh	f	0.442	8.75	1	7	2
1347	2023-02-23 21:58:00	NZ Snapper Heads	f	0.902	6.32	1	30	2
1348	2023-02-23 21:58:00	Apples Royal Gala	f	1	3.49	1	9	2
1349	2023-02-23 21:58:00	Bananas Conventional	f	1.395	4.59	1	4	2
1350	2023-02-23 21:58:00	Capsicum Loose	f	2	3.00	7	25	2
1351	2023-02-23 21:58:00	Carrots, Loose	f	1.47	4.4	1	14	2
1352	2023-02-23 21:58:00	Fresh Ginger	f	0.635	5.71	1	47	2
1353	2023-02-23 21:58:00	Mushrooms Button Loose	f	0.227	2.27	1	11	2
1354	2023-02-23 21:58:00	Onions Brown Loose	f	0.935	3.36	1	1	2
1355	2023-02-23 21:58:00	Anchor butter 500g	f	1	10.18	1	12	2
1356	2023-02-23 21:58:00	Bird n Barrow FR Chicken Whole Bag 1.35kg	f	1.35	18.49	1	133	2
1357	2023-02-23 21:58:00	NZ Beef Mince	f	0.720	11.51	1	18	2
1358	2023-02-23 21:58:00	NZ Chciken Thighs Bone In with Skin	f	0.746	5.59	1	54	2
1360	2023-02-02 23:00:00	Bulk Ceres Salt	t	1	2.65	1	75	6
1361	2023-02-02 23:00:00	Chocolate Chips, SHARE 10 kg bag	t	2	56.66	1	19	6
1362	2023-02-02 23:00:00	Bulk Adzuki Beans 3.5kg	t	3.50	31.7500	1	169	6
1363	2023-02-02 23:00:00	Bulk Red Lentils Ceres 3.5 kg bag	t	3.5	25.49	1	72	6
1364	2023-02-02 23:00:00	Organic Medium Grain Brown Rice, Bulk	t	10.5	37.67	1	71	6
1365	2023-02-10 04:00:00	Whittakers Block Cocoa Dark 72% 250g	f	250	5.29	2	17	13
1366	2023-02-10 04:00:00	Fresh Ginger	f	0.12	1.56	1	47	13
1367	2023-02-13 04:00:00	Apples Royal Gala	f	1.1	4.02	1	9	13
305	2021-10-25 19:31:00	Banana Sweetio 4 pk	f	1	3.49	6	4	13
430	2021-08-27 00:00:00	Bananas Conventional	f	1	2.57	6	4	15
434	2022-01-23 02:54:00	Arnotts Vita-weat Cracked Pepper 250g	f	250	2.99	2	3	13
622	2022-03-28 22:16:00	Onions Brown Loose	f	0.235	0.47	1	1	18
629	2022-04-05 02:37:00	Bananas Conventional	f	0.615	1.53	1	4	18
631	2022-04-05 02:37:00	Onions Brown Loose	f	0.2	0.4	1	1	18
664	2022-04-27 04:51:00	Bananas Conventional	f	1.171	3.85	1	4	13
1049	2022-09-27 21:17:00	Onions Brown Loose	f	0.152	0.45	1	1	1
1052	2022-09-27 21:17:00	Arnotts Vita-weat Cracked Pepper 250g	f	500	6.6	2	3	1
1054	2022-09-27 21:17:00	WW Thin Rice Cracker Salt&Ving 100g	f	100	1.5	2	3	1
1066	2022-10-27 21:29:00	Onions Brown Loose	f	0.386	1.08	1	1	2
1146	2022-11-20 21:15:00	Onions Brown Loose	f	0.402	1.6	1	1	1
1158	2022-11-20 21:15:00	Arnotts Vita-weat Cracked Pepper 250g	f	750	9.9	2	3	1
1368	2023-02-13 04:00:00	Pams Finest Dark Chocolate Chunks 200g	f	200	3.99	2	19	13
1369	2023-02-17 04:00:00	Lisas Hummus Gloriously Garlic 380g	f	380.00	4.99	2	158	13
1371	2023-03-07 23:24:00	Bananas Cavendish	f	0.862	3.19	1	4	1
1372	2023-03-07 23:24:00	Onions Brown Loose	f	0.967	3.37	1	1	1
1375	2023-03-07 23:24:00	WW Black Sliced Olives 430g	f	430	3.7	2	113	1
1376	2023-03-07 23:24:00	Essentials Coconut Cream 400 mL	f	1600.00	6	4	15	1
1377	2023-03-07 23:24:00	WW Dates Pitted 500g	f	2	8	1	78	1
1378	2023-03-07 23:24:00	Arnotts Vita-weat Cracked Pepper 250g	f	1	13.2	1	3	1
1379	2023-03-07 23:24:00	Cabbage Red Whole	f	1.489	5.99	1	60	1
1380	2023-03-07 23:24:00	Tasti Fruit Balls Apple 207g	f	207	5.5	2	182	1
1381	2023-03-07 23:24:00	Ceres Organics Seaweed Nori Snack 5g	t	5	2	2	131	1
1382	2023-03-07 23:24:00	CD Beef Chuck Diced 340g Reduced	f	1.02	18.54	1	51	1
1383	2023-03-07 23:24:00	CD Beef Mince 82% 1kg	f	1	12.82	1	18	1
1386	2023-03-04 22:10:00	CD 9 Thin Beef Sausages 580g	f	580	7	2	116	1
1387	2023-03-12 23:00:00	Albert's Eggs Size 7 30pk 1860g	f	1.86	17.5	1	173	11
1388	2023-03-15 20:25:00	CD Chicken Drumsticks Large	f	1.514	9.84	1	48	1
1389	2023-03-15 20:25:00	Bananas Cavendish	f	0.922	3.41	1	4	1
1390	2023-03-15 20:25:00	Essentials Coconut Cream 400 mL	f	800	3	4	15	1
1391	2023-03-15 20:25:00	WW Tomatoes Diced Italian 400g	f	400	0.9	2	41	1
1392	2023-03-15 20:25:00	WW Black Sliced Olives 430g	f	430	3.7	2	113	1
1394	2023-03-15 20:25:00	CD Butter Salted 500g	f	0.5	6.5	1	12	1
1395	2023-03-15 20:25:00	CD Beef Mince 82% 1kg	f	1	16.5	1	18	1
1396	2023-03-15 20:25:00	Jack links original beef sticks 12g	f	192.00	16	2	186	1
1397	2023-03-15 20:25:00	WW Crinkle Cut Chips Ready 150g	f	300	3.8	2	149	1
1398	2023-03-15 20:25:00	Carrots, 1.5 kg Odd Bunch	f	1.5	3.2	1	14	1
1399	2023-03-15 20:25:00	Onion Odd Bunch 1.5kg	f	1.5	3.2	1	1	1
1400	2023-03-15 20:25:00	Whittakers Block Cocoa Dark 72% 250g	f	500	9.6	2	17	1
1401	2023-03-17 03:08:00	Tararua Salted Butter 500g	f	2	19.2	1	12	20
1402	2023-03-17 04:32:00	Potatoes White Washed	f	1.312	5.23	1	2	1
1403	2023-03-17 04:32:00	WW Chocolate Drops Dark 200g	f	0.4	5.6	1	19	1
1404	2023-03-17 04:32:00	Chelsea Molasses Black Strap 500g	f	500.00	4.1	2	175	1
1405	2023-03-17 04:32:00	Hansells Mandarin Lime&Bitters 750mL	f	750	6.5	4	135	1
1406	2023-03-17 04:32:00	Whittakers Block Cocoa Dark 72% 250g	f	250	4.8	2	17	1
17	2021-06-22 23:31:00	Essentials Coconut Cream 400 mL	f	800	2.60	4	15	1
43	2021-07-27 04:29:00	Essentials Coconut Cream 400 mL	f	1200	3.9	4	15	1
81	2021-08-12 01:33:00	Essentials Coconut Cream 400 mL	f	1200	3.90	4	15	1
118	2021-07-14 22:30:00	Essentials Coconut Cream 400 mL	f	400	1.3	4	15	1
156	2021-11-23 00:42:00	Essentials Coconut Cream 400 mL	f	2400.00	7.2	4	15	1
167	2021-11-29 20:45:00	Essentials Coconut Cream 400 mL	f	400	2.4	4	15	1
230	2021-12-12 22:19:00	Essentials Coconut Cream 400 mL	f	400	1.2	4	15	1
275	2021-11-10 23:48:00	Essentials Coconut Cream 400 mL	f	800.00	2.4	4	15	1
394	2021-12-31 03:00:00	Essentials Coconut Cream 400 mL	f	1600.00	4.8	4	15	1
449	2022-01-31 23:40:00	Essentials Coconut Cream 400 mL	f	3200.00	9.60	4	15	1
511	2022-02-08 01:03:00	Essentials Coconut Cream 400 mL	f	2000.00	6.00	4	15	1
557	2022-02-28 22:11:00	Essentials Coconut Cream 400 mL	f	3200.00	9.60	4	15	1
598	2022-03-22 21:45:00	Essentials Coconut Cream 400 mL	f	1200	3.6	4	15	1
621	2022-03-28 22:16:00	Carrots, Loose	f	0.225	0.61	1	14	18
634	2022-04-05 02:37:00	Carrots, Loose	f	1	1.89	1	14	18
649	2022-04-12 22:37:00	Essentials Coconut Cream 400 mL	f	2400.00	8.4	4	15	1
672	2022-04-20 01:03:00	Essentials Coconut Cream 400 mL	f	1600.00	5.60	4	15	1
714	2022-05-18 02:05:00	Essentials Coconut Cream 400 mL	f	2400.00	8.4	4	15	1
1037	2022-10-21 06:04:00	Carrots, 1.5 kg Odd Bunch	f	1.5	3.50	1	14	1
1068	2022-10-30 22:22:00	Kumara Orange	f	0.862	3.28	1	10	1
1070	2022-10-30 22:22:00	Onions Brown Loose	f	0.137	0.41	1	1	1
1071	2022-10-30 22:22:00	Bananas Cavendish	f	0.962	3.7	1	4	1
1083	2022-11-06 20:52:00	Tribe Organic Crackers Multipack 6 x 20g	t	120	1.79	2	3	23
1090	2022-11-06 20:52:00	Westgold Unsalted Butter 400g	f	400	4.99	2	12	23
1094	2022-11-06 06:41:00	CD FR Eggs Sz 7 12 pack	f	744	8.2	2	6	1
1192	2022-12-20 20:44:00	Kumara Orange X-large	f	3.022	6.65	1	10	1
1193	2022-12-20 20:44:00	Onions Brown Loose	f	0.707	2.82	1	1	1
1195	2022-12-20 20:44:00	Bananas Cavendish	f	1.512	5.97	1	4	1
1201	2022-12-20 20:44:00	Huntley & Palmers Rosemary Garlic Crackers	f	200	3.7	2	3	1
1203	2022-12-20 20:44:00	Carrots, 1.5 kg Odd Bunch	f	1.5	3.8	1	14	1
1204	2022-12-20 20:44:00	Apples 2kg Odd Bunch	f	2	5.99	1	9	1
1248	2023-02-07 22:04:00	Onions Brown Loose	f	0.55	2.19	1	1	26
18	2021-06-22 23:31:00	Essentials French Whole Bean 200g	f	200	5	2	16	1
20	2021-06-22 23:31:00	Whittakers Block Dark Ghana 250g	f	250	4.7	2	17	1
25	2021-06-30 08:40:00	Whittakers Blk Dark Almond 62% 250g	f	250	4.70	2	17	1
44	2021-07-27 04:29:00	Whittakers Block Dark Almond 62% 250g	f	250	4.3	2	17	1
47	2021-07-29 06:26:00	Whittakers Block Cocoa Dark 72% 250g	f	750	12.90	2	17	1
83	2021-08-12 01:33:00	Macro Organic Fairtrade Medium Beans 200g	f	200	6.50	2	16	1
21	2021-06-22 23:31:00	Beef Value Mince 82% 1 kg	f	1	10.90	1	18	1
22	2021-06-30 08:39:00	WW Chocolate Chips Dark 200g	f	0.2	2.5	1	19	1
23	2021-06-30 08:40:00	Mainland Cheese Vintage 500g	f	0.5	10.5	1	21	1
27	2021-06-30 23:20:00	Pams Flour Wholemeal 1.5 kg	f	1.5	1.98	1	22	2
28	2021-06-16 00:00:00	Tulsi Tumeric Ginger Tea	f	25	0	7	20	3
29	2021-06-16 00:00:00	Tulsi Orginal Loose Leaf Tea	f	100	16.40	2	20	3
30	2021-06-16 00:00:00	Tulsi Licorice Spice Tea	f	25	9.50	7	20	3
46	2021-07-29 06:26:00	Mainland Cheese Vintage	f	500	10.50	2	21	1
52	2021-08-05 05:33:00	Pams Flour Wholemeal 1.5 kg	f	1.5	1.98	1	22	2
68	2021-08-05 05:33:00	NZ Beef Mince Special	f	0.865	8.65	1	18	2
84	2021-08-12 01:33:00	Mainland Cheese Vintage 500g	f	500	10.50	2	21	1
86	2021-08-12 01:33:00	CD Beef Mince 82% 1kg Price Reduced by $5.50	f	1	10.27	1	18	1
143	2021-07-02 00:00:00	Organic Beef Mince 90/10	t	0.4	10	1	18	8
1419	2023-03-27 22:25:00	Bulk Tapioca Flour	f	0.134	1.00	1	208	4
1420	2023-03-27 22:25:00	Bin Inn Bagged Cryst Ginger 500g	f	0.5	8.5	1	112	4
1421	2023-03-27 22:25:00	Organic Chickpeas 1kg bag	t	1	9.9	1	176	4
1422	2023-03-27 22:25:00	Ground Ginger Bulk Bin	f	0.026	1.17	1	141	4
1423	2023-03-27 22:25:00	Down to Earth Organic Cayenne Pepper 60g	t	0.06	4.99	1	220	4
31	2021-06-30 23:20:00	Pams White Sugar 3 kg	f	3	4.89	1	23	2
34	2021-06-30 23:20:00	Avocado Small	f	4	5	7	24	2
35	2021-06-30 23:20:00	Capsicum Red NZ	f	1	2.99	7	25	2
36	2021-06-30 23:20:00	Carrots Loose	f	1.261	2	1	25	2
93	2021-08-19 01:56:00	Capsicum Yellow	f	3	5	7	25	2
103	2021-08-19 01:08:00	Avocado Loose	f	2	2.50	7	24	1
113	2021-08-27 05:14:00	Loose Avocado	f	2	2.3	7	24	1
134	2021-11-15 19:44:00	Capsicum Odd Bunch 750g	f	750	5	2	25	1
174	2021-11-29 20:45:00	Avocado Loose	f	2	2.50	7	24	1
175	2021-11-29 20:45:00	Capsicum Odd Bunch 750g	f	750	5	2	25	1
191	2021-10-30 23:00:00	Local Avocado	f	1	1.5	7	24	7
204	2021-12-04 23:11:00	Pams Flour Wholemeal 1.5 kg	f	1.50	1.98	1	22	2
232	2021-12-12 22:19:00	Capsicum Odd Bunch 750g	f	750	5	2	25	1
258	2021-12-20 23:18:00	Avocado Small	f	4	2	7	24	2
49	2021-07-29 06:26:00	Pumpkin Butternut Whole Organic	t	1	3.50	7	26	1
50	2021-08-05 05:33:00	Ceres Organic Apple Cider Vinegar 750mL	t	750	7.89	4	27	2
53	2021-08-05 05:33:00	T/Colledge Vanilla Exract 100 mL FairTrade	t	100	8.99	4	28	2
54	2021-08-05 05:33:00	NZ Parore (Black Snapper) Whole	f	1.076	9.46	1	29	2
55	2021-08-05 05:33:00	NZ Snapper Heads	f	0.652	4.56	1	30	2
59	2021-08-05 05:33:00	Beetroot Conventional	f	0.276	0.96	1	32	2
61	2021-08-05 05:33:00	Mango Mexico Large	f	1	1.89	7	31	2
64	2021-08-05 05:33:00	Ben N Jerrys Choc Chip Cookie Dough Ice Cream 458mL	f	458	5	4	33	2
91	2021-08-19 01:56:00	NZ Snapper Heads x2	f	0.430	3.01	1	30	2
179	2021-11-22 23:01:00	NZ Snapper Heads	f	1.17	5.27	1	30	9
181	2021-11-15 23:00:00	NZ Snapper Heads	f	1.322	5.95	1	30	9
185	2021-11-10 23:00:00	NZ Snapper Heads	f	1	4.5	1	30	9
203	2021-12-04 23:11:00	Ceres Organic Apple Cider Vinegar 750mL	t	1500	10	4	27	2
213	2021-12-12 23:00:00	NZ Snapper Heads x2	f	1.59	7.16	1	30	9
220	2021-12-12 22:19:00	Beetroot Conventional	f	0.117	0.560	1	32	1
253	2021-12-20 23:18:00	T/Colledge Vanilla Exract 100 mL FairTrade	t	100.00	8.99	4	28	2
256	2021-12-20 23:18:00	Whole Snapper Leigh, 1.225 kg after gutted	f	1.456	23.28	1	29	2
260	2021-12-20 23:18:00	Beetroot Conventional	f	0.296	1.27	1	32	2
316	2022-01-07 01:28:00	Beetroot Conventional	f	0.172	0.83	1	32	1
329	2022-01-11 02:54:00	NZ Snapper Heads	f	0.836	5.84	1	30	2
335	2022-01-11 02:54:00	Mango Peru	f	3	5	7	31	2
347	2021-10-22 00:02:00	Beetroot Conventional	f	0.617	3.09	1	32	1
373	2021-10-31 01:06:00	T/Colledge Vanilla Exract 100 mL FairTrade	t	100.00	8.99	4	28	2
382	2021-12-31 03:00:00	Beetroot Conventional	f	0.356	1.95	1	32	1
470	2022-01-31 23:07:00	NZ Snapper Heads	f	1.344	9.39	1	30	2
494	2022-02-22 00:00:00	NZ Snapper Heads	f	1.042	7.28	1	30	2
499	2022-02-22 00:00:00	Beetroot Conventional	f	0.386	1.66	1	32	2
501	2022-02-22 00:00:00	Mango Peru	f	3	4.5	7	31	2
571	2022-03-07 21:11:00	Mango Peru	f	1	1.89	7	31	2
636	2022-04-05 02:37:00	Beetroot Conventional	f	0.255	1.27	1	32	18
679	2022-04-20 02:34:00	NZ Snapper Heads	f	0.994	6.95	1	30	2
697	2022-05-10 22:22:00	T/Colledge Vanilla Exract 100 mL FairTrade	t	200	19.18	4	28	2
65	2021-08-05 05:33:00	Pams Frozen Peas, Garden 1kg	f	1	2.69	1	34	2
66	2021-08-05 05:33:00	Eclipse Cheese Tasty 1 kg	f	1	11.99	1	35	2
67	2021-08-05 05:33:00	Bird N Barrow Free Range Chicken Whole Short Date Special	f	1.7	10.19	1	36	2
69	2021-06-21 00:00:00	Dreamview Raw Milk 1L	f	2	6	3	37	5
70	2021-06-28 00:00:00	Dreamview Raw Milk 1L	f	2	6	3	37	5
71	2021-07-05 00:00:00	Dreamview Raw Milk 1L	f	2	6	3	37	5
72	2021-07-12 00:00:00	Dreamview Raw Milk 1L	f	2	6	3	37	5
73	2021-07-19 00:00:00	Dreamview Raw Milk 1L	f	2	6	3	37	5
74	2021-07-26 00:00:00	Dreamview Raw Milk 1L	f	2	6	3	37	5
75	2021-07-28 00:00:00	Dreamview Cream 500mL	f	0.5	6	3	38	5
76	2021-08-02 00:00:00	Dreamview Raw Milk 1L	f	2	6	3	37	5
79	2021-08-11 23:07:00	Good Bugs Ginger Ninja Kimchi	f	500	16	2	39	7
80	2021-08-11 23:07:00	Local Spray Free Parsnips	f	460	3	2	40	7
82	2021-08-12 01:33:00	Macro Organic Tomatoes Diced NAS 400g	t	2000	7.50	2	41	1
101	2021-08-19 01:08:00	Macro Organic Tomatoes Diced NAS 400g	t	1600	6	2	41	1
85	2021-08-12 01:33:00	Mainland Cheese Organic 500g	t	1	21.00	1	42	1
1424	2023-03-25 22:07:00	Mexicano Corn Chips Sourcream 170g	f	170	2.69	2	56	13
90	2021-08-19 01:56:00	NZ Salmon Frames (t/p) x1	f	0.498	4.98	1	43	2
97	2021-08-19 01:56:00	Mainland Cheese Organic 500g	t	500	10.39	2	42	2
98	2021-08-19 01:56:00	NZ Organic Chicken Butterfly Bostocks Reduced	t	1.19	12.48	1	44	2
117	2021-07-14 22:30:00	Exotic Food Panang Curry Paste	f	200	3.95	2	45	1
121	2021-08-25 23:34:00	Cucumber Green	f	1	4.49	7	46	1
123	2021-07-20 00:18:00	Fresh Ginger	f	0.251	3.76	1	47	2
141	2021-11-15 20:10:00	Hoco Coconut Water 1L	f	1	2.99	3	53	2
144	2021-07-02 00:00:00	Organic Beef Chuck	t	0.4	10	1	51	8
145	2021-07-02 00:00:00	Organic Beef Blade Steak	t	0.8	20	1	52	8
177	2021-11-22 23:00:00	Organic Beef Blade Steak	t	0.4	11	1	52	8
178	2021-11-22 23:00:00	Organic Beef Chuck	t	0.40	11	1	51	8
183	2021-11-10 23:00:00	Organic Beef Chuck	t	0.40	11.40	1	51	8
193	2021-08-05 00:00:00	Organic Beef Blade Steak	t	0.4	11	1	52	8
194	2021-08-05 00:00:00	Organic Beef Chuck	t	0.40	11	1	51	8
273	2021-11-10 23:48:00	WW Coconut Water 1L	f	3	10.5	3	53	1
279	2021-11-03 23:13:00	WW Coconut Water 1L	f	3	10.50	3	53	1
352	2021-10-22 00:02:00	Delmaine Sliced Jalapenos 280g	f	280	3	2	50	1
398	2021-12-31 03:00:00	WW Coconut Water 1L	f	4	14	3	53	1
431	2021-12-21 23:00:00	Organic Beef Chuck	t	0.8	24	1	51	8
458	2022-02-01 00:24:00	Organic Beef Chuck 400g	t	0.8	21.60	1	51	8
486	2022-02-22 00:35:00	WW Coconut Water 1L	f	1	3.5	3	53	1
491	2022-02-22 00:00:00	Hoco Coconut Water 1L	f	1	3.69	3	53	2
558	2022-02-28 22:11:00	WW Coconut Water 1L	f	1	3.5	3	53	1
623	2022-03-28 22:16:00	Garlic NZ	f	0.08	2.4	1	49	18
628	2022-04-05 01:06:00	Organic Beef Chuck 400g	t	0.8	24	1	51	8
665	2022-04-20 00:00:00	Beef Chuck from Freezer	t	0.4	10.64	1	51	8
666	2022-04-20 00:00:00	Spray Free Local Garlic	f	0.037	2	1	49	8
730	2022-05-24 21:00:00	WW Coconut Water 1L	f	2	4	3	53	1
825	2022-07-07 23:06:00	NZ Beef Chuck Steak Reduced	f	0.63	9.82	1	51	2
1016	2022-08-26 00:00:00	Garlic NZ	f	0.06	2.4	1	49	1
1026	2022-09-03 00:00:00	Spray Free Local Garlic	f	3	6	7	49	8
1027	2022-09-03 00:00:00	Organic Beef Chuck 400g	t	0.8	24	1	51	8
1069	2022-10-30 22:22:00	Garlic NZ	f	0.022	0.88	1	49	1
1144	2022-11-20 21:15:00	CD Beef Chuck Steak Reduced	f	0.683	12.62	1	51	1
1169	2022-11-29 20:30:00	Garlic NZ	f	0.055	2.2	1	49	1
1194	2022-12-20 20:44:00	Garlic NZ	f	0.102	4.89	1	49	1
1199	2022-12-20 20:44:00	CD Beef Chuck Steak Reduced	f	0.613	10.90	1	51	1
1220	2022-12-11 22:24:00	CD Beef Chuck Diced 340g Reduced	f	1.02	20.25	1	51	1
1253	2022-12-26 01:58:00	Garlic NZ	f	0.047	2.26	1	49	1
129	2021-11-15 19:44:00	Chicken Thighs, Conventional, Reduced	f	0.889	7.46	1	54	1
133	2021-11-15 19:44:00	Tongariro Natural Spring Water 5L	f	5	3.90	3	55	1
137	2021-11-15 19:44:00	Mexicano Corn Chips Natural 300g	f	600	4.90	2	56	1
149	2021-11-23 00:42:00	Waitoa Free Range Chicken Thigh Fillet, Reduced	f	0.532	8.78	1	58	1
150	2021-11-23 00:42:00	Waitoa Free Range Chicken Thigh Fillet, Reduced	f	0.546	9.01	1	58	1
151	2021-11-23 00:42:00	Waitoa Free Range Chicken Thigh Fillet, Reduced	f	0.542	8.94	1	58	1
158	2021-11-23 00:42:00	WW Tuna Lemon Pepper 95 g	f	95	1.3	2	57	1
159	2021-11-23 00:42:00	WW Tuna in Springwater 95 g	f	570.00	7.8	2	57	1
164	2021-11-29 20:45:00	Macro Free Range Chicken Thigh Fillet, Reduced	f	0.49	6.49	1	58	1
165	2021-11-29 20:45:00	Macro Free Range Chicken Thigh Fillet, Reduced	f	0.546	7.47	1	58	1
166	2021-11-29 20:45:00	Macro Free Range Chicken Thigh Fillet, Reduced	f	0.474	6.36	1	58	1
1425	2023-03-29 02:45:00	ETA Ripples Ready Salted 150g	f	450.00	6	2	149	13
202	2021-07-21 00:00:00	Brewer's Yeast, from Bulk Bin	f	109	5.44	2	61	4
211	2021-12-04 23:11:00	OSM bars chocolate 6 pieces 507g NET 	f	12	25.78	7	67	2
225	2021-12-12 22:19:00	Raglan Coconut Yoghurt Vanilla 700g	t	700	12	2	69	1
226	2021-12-12 22:19:00	CD Flour Plain 1.5 kg	f	1.5	2	1	70	1
231	2021-12-12 22:19:00	Ceres Organic Brown Rice Basmati 500 g	t	500	5.79	2	71	1
235	2021-10-09 23:00:00	Almonds, Transitional, 2.5 kg bag	f	2.5	56.66	1	62	6
236	2021-10-09 23:00:00	Quinoa, Tricolor, bulk 3 kg bag	t	3	28.53	1	63	6
240	2021-10-09 23:00:00	Hemp Hearts, stock	t	1	23.86	1	66	6
270	2021-11-10 23:48:00	Macro Free Range Chicken Drumsticks	f	0.957	9.47	1	79	1
283	2021-11-03 23:13:00	Macro Free Range Chicken Mince Reduced	f	450	7	2	80	1
303	2021-11-11 01:02:00	Chicken Mince, reduced	f	0.518	7.99	1	81	2
311	2021-12-27 03:50:00	Peaches Yellow Flesh	f	0.46	2.76	1	82	2
325	2022-01-11 02:54:00	John West Pink Salmon Canned 210g	f	420.00	5	2	83	2
397	2021-12-31 03:00:00	Doritos corn chips original 170g	f	340.00	4	2	128	1
419	2022-01-17 20:17:00	Eggplant Odd Bunch 500g	f	500	2.99	2	106	1
421	2022-01-17 20:17:00	M&Ms Minis Tube 35g	f	35	1.49	2	107	1
423	2022-01-17 20:17:00	Doritos corn chips original 170g	f	170	2	2	128	1
1426	2023-04-02 03:51:00	Red Seal Lemon and Lime 20pk	f	20	1.49	7	221	23
1427	2023-04-02 03:51:00	Red Seal Peach & Pineapple Tea 20pk	f	20.00	1.4900	7	221	23
592	2022-03-15 00:29:00	Sigol Seaweed Snack Olive Oil 4g 3pk	f	12.00	2.2	2	131	1
610	2022-03-22 22:08:00	Bird n Barrow FR Chicken Whole Bag 1.7kg	f	1.7	16.99	1	133	2
612	2022-03-28 21:49:00	CD Chicken Nibbles Med Reduced	f	1.1	9.74	1	134	1
860	2022-06-08 00:00:00	French Green Lentils 3.5kg	t	3.5	29.15	1	168	6
862	2022-06-08 00:00:00	Bulk Adzuki Beans 3.5kg	t	3.5	31.75	1	169	6
906	2022-08-09 22:45:00	Macro Free Range Chicken Stir Fry 450g	f	0.45	9.63	1	170	1
911	2022-07-25 03:40:00	WW Canned Beetroot Baby Whole 450g	f	450	2	2	171	1
925	2022-08-11 22:17:00	Half Celery Reduced	f	0.5	2.49	7	172	2
945	2022-06-22 00:00:00	Organic Brown Linseeds Chantal 1 kg	t	1	10	1	174	6
959	2022-09-15 22:30:00	Chelsea Molasses Black Strap 500g	f	500	4.7	2	175	1
988	2022-08-31 23:36:00	Macro Org Olive Oil Spanish Extra Virgin 500mL	t	1	14	3	177	1
990	2022-08-31 23:36:00	Cookie Time 9 Pack Choc Chip 630g	f	630	11	2	178	1
1003	2022-09-24 23:03:00	WW Frozen Cherries 500g	f	0.5	6	1	179	1
1031	2022-10-23 04:34:00	Red Seal VitaFizz Magnesium 13s	f	13	7	7	180	1
1038	2022-10-21 06:04:00	Cookie Time 9 Pack Choc Chip 630g	f	630.00	11.0000	2	178	1
1044	2022-10-27 00:20:00	Juicies Tropical Frozen 10x100mL	f	1000	6.9	4	181	1
1048	2022-10-27 00:20:00	Tasti Strawberry & Beet Balls 207g	f	207	5.5	2	182	1
1053	2022-09-27 21:17:00	Fragata Marinated Olive 120g	f	120	4	2	183	1
1059	2022-10-27 21:29:00	Exotic Foods Green Chilli Whole 190g	f	190	3.89	2	184	2
1060	2022-10-27 21:29:00	Tasti Ready to Eat Figs 250g	f	250	6.49	2	185	2
1075	2022-10-30 22:22:00	Jack Links Jerky Teriyaki Beef 50g	f	50	4.4	2	186	1
1095	2022-11-13 06:22:00	Bitemeat Origianl Biltong 50g	f	50.00	5.3	2	186	1
1096	2022-11-13 06:22:00	Jack Links Jerky Original Beef 50g	f	50.00	5.3	2	186	1
1105	2022-11-06 22:50:00	Value Apricot Halves Syrup 410g	f	1230.00	3.57	2	191	2
1115	2022-11-06 22:50:00	Courgettes Green	f	0.301	2.56	1	192	2
1125	2022-11-22 21:40:00	Chickpeas Organic 1 kg	t	1	8.49	1	176	4
1126	2022-11-22 21:40:00	Urja Kassori Methi 50g	f	50	3.5	2	193	4
1128	2022-11-22 21:40:00	Chickpeas Bulk Bin	f	0.345	2.12	1	176	4
1152	2022-11-20 21:15:00	Red Seal VitaFizz Magnesium 13s	f	78.00	45	7	180	1
1156	2022-11-20 21:15:00	Jack Links Jerky Original Beef 50g	f	100	8.8	2	186	1
1160	2022-11-20 21:15:00	Watties Sliced Beetroot 450g	f	450.00	1.8	2	171	1
1176	2022-11-29 20:30:00	Jack Links Jerky Original Beef 50g	f	100	8	2	186	1
1180	2022-12-01 22:01:00	Jack Links Jerky Original Beef 50g	f	100	7	2	186	2
1185	2022-12-01 23:00:00	French Green Lentils 3.5kg	t	3.50	29.1500	1	168	6
1202	2022-12-20 20:44:00	Cookie Time 9 Pack Choc Chip 630g	f	630.00	12	2	178	1
1134	2022-11-20 03:43:00	Walnut Halves 140g	f	140	3.79	2	194	23
1135	2022-11-20 03:43:00	Nature Valley Crunchy Peanutbutter bars 6pk twin	f	252	2.5	2	195	23
1136	2022-11-20 03:43:00	Tribe Organics Sweet Chilli Crackers 100g	t	100	1.29	2	196	23
1137	2022-11-20 03:43:00	Tribe Organics Rice Crackers 100g	t	200	2.58	2	196	23
1138	2022-11-12 23:00:00	Amilo Ryecorn unmillled 25kg	t	25	72.5	1	197	24
1145	2022-11-20 21:15:00	CD Beef Topside Steak reduced	f	0.526	11	1	198	1
1162	2022-11-20 21:15:00	WW Chunky Salsa Mild 375g	f	375	4	2	199	1
1197	2022-12-20 20:44:00	Lamb Shoulder Chips 2 piece REDUCED	f	0.351	5.21	1	200	1
1198	2022-12-20 20:44:00	Lamb Shoulder Chips 2 piece REDUCED	f	0.408	6.06	1	200	1
1206	2022-12-20 20:44:00	Bouton D Or Feta Garlic Cumin 150g	f	150	4	2	201	1
1225	2022-11-04 00:07:00	WW Peanuts Salted 500g	f	0.5	4.4	1	202	1
1241	2023-01-03 02:02:00	CD Lamb Shoulder Chops Reduced	f	0.779	12.7	1	200	1
1245	2023-02-07 21:54:00	Rice Pops bulk bin	f	0.068	0.67	1	203	4
1250	2022-12-26 01:58:00	CD Chicken Tenderloins Small	f	0.668	10.23	1	204	1
1251	2022-12-26 01:58:00	CD Chicken Tenderloins Small	f	0.618	9.47	1	204	1
1252	2022-12-26 01:58:00	CD Chicken Tenderloins Small	f	0.619	9.49	1	204	1
1269	2023-02-01 23:00:00	CD Corned Silverside grass fed nz beef 64%beef	f	1.537	16.75	1	205	1
1273	2023-02-01 23:00:00	CD rice crackers salt and vinegar 100g	f	100	1.5	2	196	1
1282	2023-01-09 22:11:00	CD Lamb Shoulder Chops 4 piece	f	0.886	14.48	1	200	1
1295	2023-01-09 22:11:00	Sunsweet Prunes 400g	f	0.4	8.29	1	206	1
1296	2023-01-09 22:11:00	Keri Premium Orange Juice 1L	f	2	5.5	3	207	1
1298	2023-01-09 22:11:00	Ward Mckenzie Arrowroot Pwdr 175g	f	175	3.6	2	208	1
1299	2023-01-09 22:11:00	CD rice crackers salt and vinegar 100g	f	200	3	2	196	1
1304	2023-01-09 22:11:00	CD Roasted Salted Mixed Nuts 400g	f	400	11	2	209	1
1305	2023-01-09 22:11:00	ME Cashews Roasted & Salted 400g	f	400	10	2	210	1
1310	2023-01-09 22:11:00	WholeEarth Monkfruit Sweetener Gran 200g	f	200	10.5	2	211	1
1314	2023-01-09 22:11:00	Meadow Fresh Milk Standard 600 mL	f	0.6	2.38	3	212	1
1329	2023-02-13 23:15:00	Chelsea Soft Brown Sugar 500g	f	0.5	2	1	213	1
1330	2023-02-13 23:15:00	WW Peanuts Salted 200g	f	0.2	2	1	202	1
1334	2023-02-13 23:15:00	Macro Organic White Med Grain Rice 1kg	t	1	5.5	1	214	1
1340	2023-02-23 21:58:00	Pams Rice Snaps 460g	f	0.46	3.59	1	203	2
1359	2023-02-23 21:58:00	NZ Mutton Leg Chops	f	0.854	10.25	1	215	2
1370	2023-02-17 04:00:00	McCains Frozen Baby Green Beans	f	0.5	3.19	1	216	13
1373	2023-03-07 23:24:00	CD Corned Silverside grass fed nz beef 64%beef	f	1.264	15.04	1	205	1
1374	2023-03-07 23:24:00	CD Lamb Shoulder Chops Reduced	f	0.748	9.14	1	200	1
1384	2023-03-04 22:10:00	Macs Ginger Beer 4pk	f	4	5.99	7	217	1
1385	2023-03-04 22:10:00	Value Salad Green 120g	f	120	4.3	2	218	1
1393	2023-03-15 20:25:00	WW Thin Rice Cracker BBQ 100g	f	100	1.3	2	196	1
1428	2023-02-27 23:00:00	Albert's Eggs Size 7 30pk 1860g	f	1860	17.50	2	173	11
\.


--
-- Data for Name: units; Type: TABLE DATA; Schema: public; Owner: das
--

COPY public.units (id, name) FROM stdin;
1	kg
2	g
3	L
4	mL
7	Pieces
6	Bunches
5	Bags
\.


--
-- Name: conversions_complex_id_seq; Type: SEQUENCE SET; Schema: public; Owner: das
--

SELECT pg_catalog.setval('public.conversions_complex_id_seq', 3, true);


--
-- Name: categories categories_name_key; Type: CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.categories
    ADD CONSTRAINT categories_name_key UNIQUE (name);


--
-- Name: categories categories_pkey; Type: CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.categories
    ADD CONSTRAINT categories_pkey PRIMARY KEY (id);


--
-- Name: conversions conversion_check; Type: CHECK CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE public.conversions
    ADD CONSTRAINT conversion_check CHECK ((id = public.szudzik_encode(_from, _to))) NOT VALID;


--
-- Name: conversions_complex conversions_complex_check; Type: CHECK CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE public.conversions_complex
    ADD CONSTRAINT conversions_complex_check CHECK ((id = public.szudzik_encode(_from, _to))) NOT VALID;


--
-- Name: conversions_complex conversions_complex_pkey; Type: CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.conversions_complex
    ADD CONSTRAINT conversions_complex_pkey PRIMARY KEY (id, product_id);


--
-- Name: conversions conversions_pkey; Type: CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.conversions
    ADD CONSTRAINT conversions_pkey PRIMARY KEY (id);


--
-- Name: groups groups_name_key; Type: CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.groups
    ADD CONSTRAINT groups_name_key UNIQUE (name);


--
-- Name: groups groups_pkey; Type: CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.groups
    ADD CONSTRAINT groups_pkey PRIMARY KEY (id);


--
-- Name: products products_name_key; Type: CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.products
    ADD CONSTRAINT products_name_key UNIQUE (name);


--
-- Name: products products_pkey; Type: CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.products
    ADD CONSTRAINT products_pkey PRIMARY KEY (id);


--
-- Name: stores stores_name_key; Type: CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.stores
    ADD CONSTRAINT stores_name_key UNIQUE (name);


--
-- Name: stores stores_pkey; Type: CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.stores
    ADD CONSTRAINT stores_pkey PRIMARY KEY (id);


--
-- Name: units units_pkey; Type: CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.units
    ADD CONSTRAINT units_pkey PRIMARY KEY (id);


--
-- Name: units units_unique_name; Type: CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.units
    ADD CONSTRAINT units_unique_name UNIQUE (name);


--
-- Name: products fk_category_id; Type: FK CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.products
    ADD CONSTRAINT fk_category_id FOREIGN KEY (category_id) REFERENCES public.categories(id);


--
-- Name: conversions fk_from; Type: FK CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.conversions
    ADD CONSTRAINT fk_from FOREIGN KEY (_from) REFERENCES public.units(id);


--
-- Name: conversions_complex fk_from; Type: FK CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.conversions_complex
    ADD CONSTRAINT fk_from FOREIGN KEY (_from) REFERENCES public.units(id);


--
-- Name: categories fk_group_id; Type: FK CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.categories
    ADD CONSTRAINT fk_group_id FOREIGN KEY (group_id) REFERENCES public.groups(id);


--
-- Name: transactions fk_product_id; Type: FK CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.transactions
    ADD CONSTRAINT fk_product_id FOREIGN KEY (product_id) REFERENCES public.products(id);


--
-- Name: conversions_complex fk_product_id; Type: FK CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.conversions_complex
    ADD CONSTRAINT fk_product_id FOREIGN KEY (product_id) REFERENCES public.products(id);


--
-- Name: transactions fk_store_id; Type: FK CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.transactions
    ADD CONSTRAINT fk_store_id FOREIGN KEY (store_id) REFERENCES public.products(id);


--
-- Name: conversions fk_to; Type: FK CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.conversions
    ADD CONSTRAINT fk_to FOREIGN KEY (_to) REFERENCES public.units(id);


--
-- Name: conversions_complex fk_to; Type: FK CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.conversions_complex
    ADD CONSTRAINT fk_to FOREIGN KEY (_to) REFERENCES public.units(id);


--
-- Name: transactions fk_unit_id; Type: FK CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.transactions
    ADD CONSTRAINT fk_unit_id FOREIGN KEY (unit_id) REFERENCES public.units(id);


--
-- PostgreSQL database dump complete
--